OpenEuphoria

ODBC.e : Char Type Column in a Cursor with length > 50

• Posted by Rad <radhx at rediffmail?com> Jul 09, 2007
• 557 views

Hi,

I am using odbc.e 1.34 with MySQL 5.x database on WinXP Pro (SP2).

In a table, I have a column of type "char" with length 150.
I can access the entire value of this column correctly using normal select
clause.

But if I create a Cursor for the same table, only first 49 characters of the
value in this column are returned correctly, everything else is junk characters.
I tried to change the column type to "varchar", but still got the same result.

Are there any restrictions on length of character column of cursor in odbc.e?
How to get the entire available value of char column with length greater than 50
from a cursor?

Regards,
Rad.