问题描述
如果我在Oracle中将现有的列类型从varchar2更改为nvarchar2，Oracle会自动在字符集之间转换现有的列数据还是我自己做?
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?
我正在使用Oracle 11g，varchar2字符集是WE8MSWIN1252，nvarchar2字符集是AL16UTF16
I'm using Oracle 11g, the varchar2 character set is WE8MSWIN1252 and the nvarchar2 character set is AL16UTF16
推荐答案
您可以使用DBMS_REDEFINITION包将表的varchar2列更改为nvarchar2列
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
这篇关于Oracle varchar2到nvarchar2的转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！