Help Center/ GaussDB(DWS)/ Troubleshooting/ Database Use/ When the ODBC Driver of GaussDB(DWS) Is Used, Content of Fields of the Character Type in the SQL Query Result Is Truncated

When the ODBC Driver of GaussDB(DWS) Is Used, Content of Fields of the Character Type in the SQL Query Result Is Truncated

Updated on 2022-09-15 GMT+08:00

Symptom

When the ODBC driver of GaussDB(DWS) is used, the content of fields of the character type in the SQL query result is truncated. To obtain the complete field information, use the SQL syntax CAST BYTEA to convert the field content into binary. However, when the same program connects to the Oracle database and SQL server, this fault does not occur.

Possible Causes

The max varchar parameter is set to 255 on the ODBC client. As a result, fields that have more than 255 characters are truncated.

Handling Procedure

On the ODBC client, increase the value of max varchar.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback