Re: Problem Importing Special Characters

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?
>

Prompts are not something the import *tool* issues. Be careful with your choice of words, here, as Oracle knows a tool called import (the IMP executable). It caused misunderstanding, at least at my side.

You seem to use SQL*Plus - that prompts when encountering an ampersand (&). You can suppress that by issueing set define off
before you do your "import".
The expression, used by SQL*Plus when it encounters "S&P, Müller and Sägen" would be:
Please supply a value for: P, Müller and Sägen (unless you mean Müller & Sägen as a sperarate entry; then it would be:
Please supply a value for: P

   and:
Please supply a value for: Sägen)

-- 
Regards,
Frank van Bortel