Welcome to the Oracle community forum, and interact with 2 million technical staff to enter the oracle database character set taiwen warehouse receiving question. Today, the imported database field content is taiwen data, which is always displayed as question marks, copy, paste, and display Thai text, insert and display question marks with insert, Baidu is a character set problem; it turns out that plsql's Character Set and ora
Welcome to the Oracle Community Forum, interact with 2 million technical staff> enter the oracle database character set taiwen warehouse receiving problem today, the imported database field content is taiwen data, always shown as question mark, copy, paste, and display Thai text, insert and display question marks with insert, Baidu is a character set problem; it turns out that plsql's Character Set and ora
Welcome to the Oracle community forum and interact with 2 million technical staff> enter
Oracle Database Character Set Thai text warehouse receiving Problem
Today, I encountered a problem where the field content of the imported database is taiwen, which is always displayed as a question mark. You can copy and paste it to display taiwen, and insert it to display a question mark. Baidu is a character set problem ;;
The plsql character set is different from the oracle character set,
1. If you want to be able to insert Thai text, change the field type to NVARCHAR2 ()
2. Modify plsql to UTF-8 by creating an environment variable: NLS_LANG. content:
AMERICAN_AMERICA.UTF8 restart pl/SQL
3. oracle changed to UTF-8. Baidu seems to require dba to log on.
I used to use UTF-8.