| Nvarchar(4000) with setting chararterset to UTF8. [message #452553] |
Thu, 22 April 2010 10:04  |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
Hi,
Pls suggest on the scenario.
Users are repoting that are unable to use the NVARCHAR(4000) due to the characterset which is set in the database.
Currently NLS_CHARACTERSET is set to AL32UTF8
and NLS_NCHAR_CHARACTERSET from AL16UTF16
They want me to change both the character set to UTF8, so that they can use the NVARCHAR2(4000) datatype in their tables.
As UTF8 is the subset characterset and I did the csscan and this found characterset cannt be modified to UTF8 and there may be the datadictionary corruption.
Pls suggest, Is there any other way so that users can use the NVARCHAR(4000) as datatype.
And the reason why NVARCHAR2 is required is, users are trying to import the data from other database which is using NVARCHAR(4000) as one of the field.
your suggsestions are much appreciated.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Nvarchar(4000) with setting chararterset to UTF8. [message #452562 is a reply to message #452553] |
Thu, 22 April 2010 10:36  |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
Hi,
Actually users are importing data, and source DB is using characterset UTF-8 and destination DB is using NLS_CHARACTERSET as AL32UTF8 and NLS_NCHAR_CHARACTERSET as AL16UTF16 and while importing data oracle throws characterset error.
Thanks for your preciuos time.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
