Until the problem description: oracle character set is ZHS16GBK, project in production stage suddenly have a document for Latin characters, on the Internet after baidu, changing the oracle character set to UTF8 can solve the problem, so there will produce a question of the length of a data type, involving thousands of tables, so I ask is there a better way to solve this problem

CodePudding user response:

Oracle change character set is very troublesome, and even changed my success, follow-up may also have a lot of hidden trouble, do not recommend the character set,

CodePudding user response:

https://www.cnblogs.com/andy6/p/5701219.html
You can see this article,

CodePudding user response:

16 GBK utf8 instead is no problem, but the length of the problem seems to only change manually,

CodePudding user response:

Oracle database in addition to the field set, and national character, national character set AL16UTF16 and UTF8 two types, can preserve the national character set in NVARCHAR2 field types of data,