0
votes
0answers
72 views

Change national character set for import

I had to import an dump file to an oracle 11.2 express database instance. The target instance uses AL16UTF16 for the national character set encoding, but the source instance uses UTF8. So the problem ...
4
votes
1answer
788 views

Do I need to use NVARCHAR rather than VARCHAR to properly store UTF8 characters in Oracle?

I want my Oracle database to properly store ALL possible UTF8 characters. If NLS_CHARSET is set to AL32UTF8 is that all I need to do? Or do I need to also make sure I use NCHAR and NVARCHAR rather ...
2
votes
1answer
311 views

Oracle 10 to 11: charset issue

I was redirected from SE's root site to this one. I'm not a DBA, so I shouldn't be doing this, but I have to, so I apologize beforehand to all of you DBAs that will read this post: I'm migrating an ...
3
votes
2answers
1k views

Character Set Database Migration

This is a follow-up question to a previous thread I had posted. We're in the process of migrating to a new character set. Now, I am a programmer and we have DBA's who will be performing the work but ...
1
vote
1answer
3k views

€ Euro sign/symbol not showing up on Oracle 10gr2 and aix 6.1

this is Oracle 10gr2 on aix 6100-02 The issue is that I do not manage to see the € sign from Oracle. This is an easy way to see the issue: SQL> insert into prueba values ('€'); SQL> commit; ...
2
votes
0answers
2k views

Encoding problems with sqlplus, Linux

I use sqlplus and all non-Latin characters appear as '?' when I run select queries. When I run insert or update queries with non-Latin characters I get question marks on a web page. select * from ...
2
votes
1answer
1k views

ORA-12899: importing a .dmp file + character set conversion

I'm working on a django project on Ubuntu 10.04 with Oracle Database Server , so I've installed: Oracle Database 10g xe universal Rel.10.2.0.1.0 cx_Oracle-5.0.4-10g-unicode-py26-1.x86_64 When I ...
2
votes
2answers
1k views

Is there any doc listing standard <=> Oracle character sets correspondencies?

I'm looking for a table listing Oracle and "standard" character sets, for example: Oracle Standard ------------ ---------- WEISO98859P1 iso-8859-1 AL32UTF8 utf-8 etc. etc. Does ...
4
votes
2answers
11k views

Determine Oracle session client character set?

I know how the database characterset (NLS_CHARACTERSET in select * from v$nls_parameters;) and the client character set (the client environment setting NLS_LANG) interact. What I can't find out ...
3
votes
1answer
2k views

What does WE8DEC mean?

It is one of the commonly used character sets. What does it stand for? Is it an acronym for something?