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
Updated on 2022-07-04 GMT+08:00

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

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.