Re: Import character set issue:

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:<1107521752.633206.58330_at_o13g2000cwo.googlegroups.com>...
> Francesco M. wrote:
> > Hi all,
> > I have exported on table from one DB to another. I have this issue:
> >
> > import done in US7ASCII character set and AL16UTF16 NCHAR character
> > set
> > import server uses WE8ISO8859P1 character set (possible charset
> > conversion)
> > export server uses US7ASCII NCHAR character set (possible ncharset
> > conversion)
> >
> > I have found an interesting article which explains how to indentify a
> > character set:
> > http://www.dbaoncall.net/references/ht_identify_charset.html
> >
> > but I haven't found which are the right steps to avoid this issues.
> > Should I change NLS_LANG before import, should I let Oracle do the
> > conversion...or what else ?
> > Thanks a lot
> > Francesco
>
> Try to minimize the number of characterset conversions done during
> exp/imp. To do that, set your client NLS_LANG to exactly the same as
> the source database characterset, this would gaurantee no conversions
> during export. Then keep the same NLS_LANG setting while importing
> which means there will be only one conversion done during the entire
> process.
>
> Remember, exp and imp are client tools thus they will use the
> characterset from NLS_LANG environment variable and NOT the database
> characterset. If either is different, conversion will take place.
>
> Regards
> /Rauf

Hi, thank you very much for your answers. Actually this is what I did: At first I identified that the export was done with US7ASCII

0000000 0300 0145 5850 4f52 543a 5630 392e 3032 <---- US7ASCII 0000020 2e30 300a 4453 5953 5445 4d0a 5255 5345 0000040 5253 0a31 3032 340a 300a 3332 0a30 0a00 0000060 0100 1f07 d000 0100 0000 0000 0000 0000 0000100 0a00 2020 2020 2020 2020 2020 2020 2020 0000120 2020 2020 2020 2020 2020 2020 2020 2020

So before using imp:
$ export NLS_LANG=US7ASCII

Unfortunately when I launch the imp utility I get this error:

IMP-00058: ORACLE error 12705 encountered ORA-12705: invalid or unknown NLS parameter value specified

Should I set NLS_LANG with a code that identifies US7ASCII ?? where am I wrong ?
Thanks again
Francesco Received on Mon Feb 07 2005 - 08:22:16 CST