Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Load multilingual data in a Unicode Database
Hello Christine,
I had to fight with this for a looong time before I figured it out. I was trying to get data from Unicode to the other languages (7 in our cases...).
Here's the trick : set up your NLS_LANG parameter to the character set you are trying to load (it might not be useful for impoting data but it is crucial for extracting it). THEN, look at you Oracle book for a function called CONVERT which will take a string in a charset and convert it to the other. For example :
convert(tstr,'AL24UTFFSS','WE8ISO8859P1') (Euro languages) convert(tstr,'AL24UTFFSS','ZHS16CGB231280') (Simplified Chinese)
Let me know if this works out!
Ciao, P
Christina Gritzapi wrote:
>
> Hello everyone,
> my name is Christine and I want your help.
> I have created an Oracle database (8.0.4 - Solaris) with Unicode
> (AL24UTFFSS) character set
> because I want to manage multilingual data.
> My data are stored in text files (Greece,French etc) and I want to load
> them in my database using the SQL Loader.
> My problem is that I don't know how to do it.
> I have created a table with NVARCHAR2 fields and I have called Loader to
> load the data in it but I got garbage.
> Also I have tried to convert my data in Unicode format (ΐ etc
> instead of characters) and then load them but I got garbage again.
>
> Can anyone please help me
>
> Christine
Received on Mon Jun 01 1998 - 00:00:00 CDT