Home > database >  11 g database table structure contains Chinese, how to import
11 g database table structure contains Chinese, how to import

Time:10-25

Consult a great god, and I do before the database table graph save trouble, table structure of the definition of the field name in Chinese, I am now on another computer to install the same version of the database, want to put the database before the guide, the result all the table structure containing Chinese field import is not successful, is Chinese annotation also shows garbled, refer to the great god, how can I guide to guide all the data in? Thank you very much! Later when creating a table, he honestly in English,

CodePudding user response:

The database character set consistent with source library

CodePudding user response:

reference 1st floor minsic78 response:
database character set and source-sink consistent

Before now new library data, delete the reconstruction, consistent with the source database character set,

CodePudding user response:

Why do field name in Chinese, do not use Chinese name field name,

CodePudding user response:

Use expdp should be no problem, exp to specify the character set before export environment variables,

CodePudding user response:

Create an environment variable NLS_LANG=SIMPLIFIE DCHINESE_CHINA. ZHS16GBK
  • Related