Dear all,
Well, after I change my character set on my database 11204 from 1252 to AL32UTF8, I tested insert with different characters like this:
Drop table scott.test purge;
Create table scott.test ( LANGUAGE_NAME VARCHAR2(40 CHAR), WELCOME_TRANSLATION VARCHAR2(40 CHAR));
insert into scott.test values ('Modern Greek','Καλώς Ορίσατε');
insert into scott.test values ('Chinese - Cantonese','歡迎');
insert into scott.test values ('Chinese - Mandarin','歡迎光臨');
insert into scott.test values ('Bengali','স্বাগতম');
insert into scott.test values ('Arabic','أهلاً و سهلاً');
insert into scott.test values ('Georgian','კეთილი იყოს თქვენი');
insert into scott.test values ('Gujarati','પધારો');
insert into scott.test values ('Lao','ຍິນດີຕ້ອນຮັບ');
insert into scott.test values ('Persian - Farsi',' خوش آمدید');
insert into scott.test values ('Limburgish','Wilkóm');
insert into scott.test values ('Korean','환영합니다');
insert into scott.test values ('Japanese','ようこそ');
insert into scott.test values ('Russian','Добро пожаловать!');
insert into scott.test values ('Czech','Vítáme tĕ');
insert into scott.test values ('Polish','Witam Cię');
commit;
select * from scott.test;
Well, as per I'm describing, the results looks good on :
- Toad for Oracle 11
- PL/SQL developer 11
- SQL developer
but, when I try to view from my command line (sqlplus) those characters doesn't show correct.
Actions done:
action 1:
chcp 65001
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8 (on DOS)
execute sqlplus
select * from scott.test;
action 2:
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
execute sqlplus
select * from scott.test;
action 3:
I have created NLS_LANG on "environment variables" on computer properties on the USER VARIABLES and I put the same value of the above actions (AMERICAN_AMERICA.AL32UTF8)
execute sqlplus
select * from scott.test;
But those actions do not change anything.
Facts:
Oracle db 11204
SELECT *
FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER LIKE '%CHARACTERSET'; 2
PARAMETER------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8
NLS_NCHAR_CHARACTERSET
AL16UTF16
Client side (from I execute sqlplus through command prompt)
windows 7 SP1
oracle client 11201
I saw: this:
how to use sqlplus with utf8 on windows command line
but, seriously, I cannot got it.
I read the articles on metalink:The Correct NLS_LANG in a Microsoft Windows Environment (Doc ID 179133.1)
and on this they describe the following:
Note that:
* The "Unicode" "chcp 65001" and "chcp 65000" values are NOT supported with sqlplus.exe.
really? that means I never saw all characters through sqlplus executed on command window?
If u know any other method to view those characters, please your kindly help.
thanks a lot