Export UTF8 db 
Author Message
 Export UTF8 db

The db is using character set UTF8. The NLS_LANG env variable is set
to AMERICAN_AMERICA.WE8ISO8859P15

During export the following text (as expected) is observed in the
export log file.
"Export done in WE8ISO8859P15 character set and UTF8 NCHAR character
set
server uses UTF8 character set (possible charset conversion)"

I use this export dump to create a db on another box with NLS_LANG env
variable set to AMERICAN_AMERICA.WE8ISO8859P15

And the following text (again, as expected) is observed in the import
log file.
"import done in WE8ISO8859P15 character set and UTF8 NCHAR character
set
import server uses UTF8 character set (possible charset conversion)"

Is there a potential problem in my new database? How can I verify if
there does exist a problem or not?

Thanx.



Wed, 24 Mar 2004 02:35:53 GMT
 Export UTF8 db


Quote:
> The db is using character set UTF8. The NLS_LANG env variable is set
> to AMERICAN_AMERICA.WE8ISO8859P15

> During export the following text (as expected) is observed in the
> export log file.
> "Export done in WE8ISO8859P15 character set and UTF8 NCHAR character
> set
> server uses UTF8 character set (possible charset conversion)"

> I use this export dump to create a db on another box with NLS_LANG env
> variable set to AMERICAN_AMERICA.WE8ISO8859P15

> And the following text (again, as expected) is observed in the import
> log file.
> "import done in WE8ISO8859P15 character set and UTF8 NCHAR character
> set
> import server uses UTF8 character set (possible charset conversion)"

> Is there a potential problem in my new database? How can I verify if
> there does exist a problem or not?

> Thanx.

Just read the messages
During export you convert from UTF8 to WE8ISO8859P1, because of the
(incorrect) NLS_LANG setting.
During import you reserve the process due to another incorrect NLS_LANG
settting.
You're going to loose your precious special characters.
You need to set the last bit of NLS_LANG to UTF8, or you will get character
set conversion.

Hth,

Sybrand Bakker, Senior Oracle  DBA



Wed, 24 Mar 2004 03:18:22 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Solution: UCS2 / UTF8 / Oracle / Fail to convert between UTF8 and UCS2

2. Character set conversion to UTF8 from WE8ISO8859P1 to UTF8

3. exporting data in UTF8 format problems - any suggestions?

4. Export & Import with UTF8 Character Set

5. UTF8: Read/Write to DB

6. Newbie : How to export a big DB (~60GB) (like Oracle export)

7. Exporting Tables From a SQL 6.5 db to a SQL 7.0 db

8. export data from one access db to same db on another machine using vb6

9. Exporting Access DB to DB III thru VB?

10. Exporting an 8.1.6 db for a 7.3 db

11. Db-export/Db-Import

12. Export Data automatically from Informix DB to Oracle DB


 
Powered by phpBB® Forum Software