Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Running UNICODE scripts
Carlos wrote:
> So we finally did it!
> We moved from 8.1.6 WE8ISO8859P1 to a brand new 9iR2 AL32UTF8 Unicode
> Database.
> Also, after some headaches, we've been able to populate the tables and
> set up the sqlplus to see asian unicode characters.
> We managed to load unicode data with sqlldr too...
> ...but still no ideas about running unicode scripts from sqlplus (with
> @, @@ or 'start' command) with asian unicode characters within.
> It seems the sqlplus buffer does not read well these files, and I
> cannot seem to get things go right. I tried almost all possible
> combinations for NLS_LANG environment variable with no luck at all. I
> also tried different unicode encodings for the file: same result.
>
> Any suggestions, Sirs?
>
> Thanks in advance and greetings from Spain.
Set your nls_lang environment correct before kicking off sqlldr...
Platform could be helpful info here.
-- Regards, Frank van BortelReceived on Mon Nov 10 2003 - 15:08:48 CST