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
