Do dbGet() has a size limitation?

[Ficko]

I have a little problem here may somebody already encountered with it and can give me some hint. 

I have a MySQL Table with a field type
VARCHAR  (1000 Char long) and another type
TEXT (65535 Char).

Using Connector/ODBC 3.51.12.

I am trying to bind an Istring variable with the corresponding length or longer but I am getting only 254 Characters back.

DEF Text[65536] AS Istring

dbBindVariable(hstmt, 1, Text)
dbGet(hstmt)

Is it dbGet() who is cutting my field or should I look somewhere else?

Thanks for any help!

[LarryMc]

Look at dbBindVariable in the help file.

[Ficko]

Cool !
I had missed that one!

Thanks Larry!

[Ionic Wind Support Team]

For those that are just perusing the topic dbBindVariable has an optional parameter to specify the maximum size of the data to be returned.

dbBindVariable(hstmt, 1, Text, NULL, 65535)