Text column does not display correctly
You have a table containing one or more columns where data type is TEXT and its data is not being displayed correctly in WinSQL. Instead of displaying the actual value, you see the ASCII code in the result.
Steps to reproduce
Create a table with following script
CREATE TABLE Test_Table (
Column1 TEXT NOT NULL
Then, insert a row using the following query.
INSERT INTO Test_Table ( Column1 ) VALUES ( 'a' )
Instead of seeing an a
you see a number. Refer to the image on the right to see how the results look like in WinSQL.
This problem is caused by a bug in the ODBC driver. Refer to this page
for a description.