MySQL 5.0, ODBC 5.1 and text fields

data in text fields doesn't want to be displayed on the site

[Harvs]

Hi,

We have recently moved our site to a new server and are now using MySQL 5, ASP 3 and ODBC driver 5.1. I have just run into an issue today where the site doesn't seem to be able to read any data from a text field.

I tested this out by creating a varchar field and putting some data in and I was able to read it just fine with the website. I changed the field to a text field and now nothing is being returned.

Has anyone come across this problem or know of a possible solution?

Harvs

[johnhh]

Stumped me too once.

If you call the data through a query don't use "select * from table_name"

Try stating the fields making the text field the last one.
e.g "select field1,field2,field3_text from table" then use the fields in order . I usually transfer them to variables making the text field (field3_text) the last one to transfer to a variable.

If you have more than one text field specify them last e.g. "select field1,field2,field3_text,field4_text from table_name"

there are other ways of doing it by streaming the data - but the above worked for me OK.

note: we use an older version of Mysql than you do