Oracle varchar2到nvarchar2的转换 [英] Oracle varchar2 to nvarchar2 conversion

问题描述

如果我在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的转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！