Posted on 2007-03-27
i want to create a unicode database in oracle8i. i have created an instance with the charset UTF-8 . how can i confirm that this database is unicode supported ?
i tried a few things but i am not sure. i created a table :-
create table test(
then i insert a thai value using the line : insert into test values ('ทฟพอริ');
if i retrieve this value in sqlplus , i get to see the result correctly in thai font. However , if i use Powerbuilder PB10.5 to retrieve it, i see alien fonts like ·¿¾ÍÃ×
so i would like no know how can i confirm that my database is unicode compliance , how can i insert data into the database in unicode format ?
can anyone help me on this ?