WinSQL » Knowledge base

Document information

Document ID:3328
Subject:TEXT column display ASCII code in MySQL instead of actual value
Creation date:4/11/14 10:47 AM
Last modified on:4/11/14 11:02 AM


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.


Solution

This problem is caused by a bug in the ODBC driver. Refer to this page for a description.




Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users? Please add it below. Your name and tip will appear at the end of the document text.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com