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

"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