Sql script not able to insert unicode data in table
467260Dec 20 2005 — edited Jan 4 2006hi
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!