Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql script not able to insert unicode data in table

467260Dec 20 2005 — edited Jan 4 2006
hi

i have a sql script which using insert statements inserts unicode characters into the table.
however the sqlscript has to be saved in unicode (1200) format(for the unicode characters to be saved in it).

hence when i try to run the script using sqlplus it fails as it tries to open the file in normal 1252 mode and finds junk in it.

using sql +plus worksheet, the script runs but inserts junk characters.

the database character set is AL32UTF8 and fields that i try and insert are nvarchar fields.

when i just use a single insert statement using table editor, unicode data is inserted fine.
when i just use a single insert statement using sql +plus worksheet, data is ???? .


1) how do i save a sqlscript with unicode data?
2) how do i run it to insert unicode data into the table?

(all the characters are a mixture of different languages.these fonts are not present on my system )
i have witten a c++ program to generate these sql scripts.
eg INSERT INTO SKILLTYPE (SKILLTYPECODE, SKILLTYPEDESC) VALUES ('Ή', 'Ήεàĺ†ћ & §àƒε†ý');

help is needed urgently and would be truely appreciated!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2006
Added on Dec 20 2005
3 comments
15,099 views