| NLS_LENGTH_SEMANTICS and IMPORT [message #56140] |
Fri, 07 March 2003 08:22 |
Greg
Messages: 35
Registered: July 2000
|
Member |
|
|
Hi all,
my database: Enterprise Edition Release 9.2.0.1.0 on AIX 5.1. NLS_LENGTH_SEMANTICS=CHAR, CHARACTER SET=AL32UTF8
I am trying to import data from EE Rel 8.1.7.0.0 with EE8ISO8859P2 and Oracle imports varchar2 columns using byte semantics instead of character one.
Result: I can't import rows where varchar2(n) column contains more than n bytes in the new database (because of some German, French, Italian, ... characters).
Can anyone answer my questions?
Is it documented that NLS_LENGTH_SEMANTICS=CHAR doesn't affect imported tables? Definitely doesn't affect existing ones (documentation says that).
What should I do to solve this problem? I know I can always run "create" scripts and import rows but it's not the best way to do it.
thanks
/greg
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
