Oracle for Chinese conditional query because of different character set, empty query result

Source: Internet
Author: User

Oracle data query using C # for SQL or ASP. When the query condition exists in Chinese , because the data server and client/natively have different character sets , the data table has data, but the data is not queried. However, data queries can be made using the same string as the Oracle tool. Search terms Chinese to '??? Appear

SELECT   Sql_text, last_load_time from    v$sql   WHERE last_load_time isn't nullorder by Last_load_time DESC
The statement is viewed by the Oracle execution SQL statement.
Solution: Add unicode=true after c#sql connection to the database string

Oracle for Chinese conditional query because of different character set, empty query result

Related Article

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.