Help Center> Data Warehouse Service> 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
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.
Parent topic: Database Use
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.