《Oracle Globalization Support Guide》有个建议: - Use AL32UTF8 to setup an Unicode database so that you can save original text in BLOB - Use AL16UTF16 as national character set so that the length of NVARCHAR is always the number of characters.请问 你的column是 varchar(n), varchar(n, char) 还是 nvarchar(n)? NLS_CHARACTERSET=? NLS_NCHAR_CHARACTERSET=?我用Oracle不多,中文数据库的经验更少。瞎猫而已。
- Use AL32UTF8 to setup an Unicode database so that you can save original text in BLOB
- Use AL16UTF16 as national character set so that the length of NVARCHAR is always the number of characters.请问
你的column是 varchar(n), varchar(n, char) 还是 nvarchar(n)?
NLS_CHARACTERSET=?
NLS_NCHAR_CHARACTERSET=?我用Oracle不多,中文数据库的经验更少。瞎猫而已。
我们改的是NLS_NCHAR_CHARACTERSET='AMERICAN_AMERICA.US7ASCII'
我想你把他们改成‘AL16UTF16’应该可以。
把16GBK改成AMERICAN_AMERICA.US7ASCII就可以了