Oracle varchar2 to nvarchar2 conversion

oracle character-encoding varchar2
user1399160 picture user1399160 · Jul 10, 2012 · Viewed 9.7k times · Source

If I change an existing column type from varchar2 to nvarchar2 in Oracle will Oracle automatically convert existing column data between character set or should I do it myself?

I'm using Oracle 11g, the varchar2 character set is WE8MSWIN1252 and the nvarchar2 character set is AL16UTF16

Answer

psaraj12 picture psaraj12 · Jul 10, 2012

You can use the package DBMS_REDEFINITION for doing the changing the varchar2 to nvarchar2 column for a table

Please find the below link which might be helpful

Using Online Table Redefinition to Migrate a Large Table to Unicode

Also find the documentation for General Character set Migration

General Character set Migration

Related questions

difference between NLS_NCHAR_CHARACTERSET and NLS_CHARACTERSET for Oracle

i have a quick question here, that i would like to know the difference between NLS_NCHAR_CHARACTERSET and NLS_CHARACTERSET setting in oracle ?? from my understanding NLS_NCHAR_CHARACTERSET is for NVARCHAR data types and for NLS_CHARACTERSET would …

Read More
How do I check the NLS_LANG of the client?

I'm working on Windows OS, I know that this setting is stored in the registry. The problem is that the registry path changes from version to version, browsing though that bunch of registry keys is definitly not a good idea. …

Read More
Defining a Character Set for a column For oracle database tables

I am running following query in SQL*Plus CREATE TABLE tbl_audit_trail ( id NUMBER(11) NOT NULL, old_value varchar2(255) NOT NULL, new_value varchar2(255) NOT NULL, action varchar2(20) CHARACTER SET latin1 NOT NULL, model varchar2(255) CHARACTER SET latin1 NOT …

Read More