Plsql developer Query contains Chr (0) string display is not complete problem

Source: Internet
Author: User
Tags chr

"Problem phenomenon"

Received Maintenance group complaint ticket, the user uplink SMS to 10086 SMS processing business failure, the results of query data display is empty.

Under normal circumstances, the system will be empty text messages filtered out, the user's uplink SMS has entered the business engine storage.

Maintenance with Plsql Developer View SMS field display blank, click Details also no content can be copied.

However, users can see the upstream content in the user acceptance details query.

"Preliminary judgment"

User upstream there must be content, uplink SMS estimation coding problems, the database is not displayed.

Processing

Use length to see the length of the field, greater than 0, to determine the content. Baidu VARCHAR2 content is not displayed.

Found Plsql developer on a string containing Chr (0), showing a defect:

When a string contains Chr (0), the Plsql developer program only takes the contents of Chr (0), which is related to the string in C + + with the-do terminator.

such as SELECT ' abc ' | | Chr (0) | | def ' from dual; results only show ABC

Replace this invisible character with replace:

Select replace (CONTENT,CHR (0), ') from TableName;

Plsql developer Query contains Chr (0) string display is not complete problem

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.