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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem Importing Special Characters

Re: Problem Importing Special Characters

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 28 Feb 2005 16:21:36 +0100
Message-ID: <cvvcpm$5oq$2@news6.zwoll1.ov.home.nl>


Paul Izzo wrote:
> I created the second database based off of the first database. If a
> table colunm is defined as CHAR(5) then it should also be the same in
> the target database.
>
> I double checked the colunms in question and they are all
> identicalially defined as VARCHAR2(30).
>
> I was prompted during import for words like S&P, Müller and Sägen.
> But the strange thing was that it wasn't for every record with these
> special letters. Other words imported with no problem from the 250,000
> records I was only prompted about 20 times.
>
> What could make this happen some times and not all the time?
>

Oh - and the
  set nls_lang=AMERICAN_AMERICA.WE8ISO8859P1 still stands....
On a command prompt, issue:
c:\> set nls_lang=AMERICAN_AMERICA.WE8ISO8859P1 c:\> sqlplus .....

-- 
Regards,
Frank van Bortel
Received on Mon Feb 28 2005 - 09:21:36 CST

Original text of this message

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