Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Running UNICODE scripts

Re: Running UNICODE scripts

From: Frank <fbortel_at_home.nl>
Date: Mon, 10 Nov 2003 22:08:48 +0100
Message-ID: <booua0$lua$1@news1.tilbu1.nb.home.nl>


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 Bortel
Received on Mon Nov 10 2003 - 15:08:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US