Unicode on Oracle 8i

From: baka <sli_at_venaca.com>
Date: 7 Feb 2002 14:49:20 -0800
Message-ID: <ec269823.0202071449.6a16af8_at_posting.google.com>

Hi all,

I am trying to insert unicode characters into a oracle database and being able to query out.

here is the server settings,
solaris 8 (sparc), oracle 8.1.7, db using UTF-8

NLS_CHARACTERSET
UTF8 NLS_NCHAR_CHARACTERSET
UTF8 I create the db using sqlplus,
sqlplus>create table names (last_name nvarchar2(60), first_name nvarchar2(60));
sqlplus>insert into names values (N'4E00', N'4E94');

am I doing it right? or (N'\u4E00', N'\u4E94'), or (N'0x4E00', N'0x4E94')?

but when I do select * from name, I got back whatever inside the quotes ('')

Also, is there a way to tell how they are being encoded? from one msg, I saw someone do this
select dump(col, 1016)? <--- what for? what 1016 stands for?

this is what I got back when I do select dump (last_name, 1016) from names;

DUMP(LAST_NAME,1016)

---

Typ=1 Len=4 CharacterSet=UTF8: 34,45,30,30 #the values are 4E00, 4E94

Typ=1 Len=4 CharacterSet=UTF8: 74,65,73,74            #test, test
Typ=1 Len=6 CharacterSet=UTF8: 30,78,34,45,30,30      #0x4E00, 0x4E94
Typ=1 Len=8 CharacterSet=UTF8: 22,30,78,34,45,30,30,22#"0x4E00",
"0x4E94"
Typ=1 Len=6 CharacterSet=UTF8: 5c,75,34,45,30,30      #\u4E00, \u4E94

any suggestions/helps are greatly appreciated.

Sing Received on Thu Feb 07 2002 - 23:49:20 CET