Tagged Questions
4
votes
1answer
69 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
144 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
606 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 ...
0
votes
1answer
1k 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
1k 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
764 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
671 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
6k 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
1k 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?
