Re: Export/Import and NLS

Here is the "unsupported" answer I got from oracle on getting us7ascii export into a we8iso8859p1 database (they gave 3 things to try - here is the one that did actually work)

• export the us7ascii database
• using a binary editor change the third byte of the export(.dmp) file from 0x01 to 0x1f

-import into the we8iso8859p1

(I had to write a quick gcc program to do this because of the file sizes)

Hope this helps.

    Mike Merrett

Pei L. Ku wrote in message <7aphj2$40h$1_at_news-1.news.gte.net>...
>Hello,
>
>I'm exporting data from a Oracle 7.2.3 database. This database was created
>with US7ASCII char set. Some tables in this database, however, contains
>Western European characters (e.g., ascii value 128 to 255). On a different
>machine I've created a 8.0.4 database using WE8ISO5589P1 (or something like
>that). When I import the 7.2.3 export into the 8.0.4 database, I noticed
>that all ascii in the 128 to 255 range got converted to ascii b/w 0 and
127.
>
>I did look up Oracle manuals and in several places it mentioned that if I
>set NLS_LANG to the char set of export file then I'll be ok. So I set
>NLS_LANG to _.US7ASCII before start the import. Didn't work. I then tried
>several other permutations of NLS_LANG values on both the import and export
>side and still I had no luck.
>
>What gives? btw, I've verified that the export does contain ascii 128 to
>255 (by importing the data back into the 7.2.3, US7ASCII database), so the
>unwanted conversion is occurring on the import side.
>
>thanks
>
>Pei
>
>
Received on Wed Feb 24 1999 - 11:50:55 CST