Oracle Database Character Set Thai text warehouse receiving Problem

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.