How to store long string from VB6 to MySQL database

[rony good]

Hello,

I want to store string data from vb6 program to a column
of MySQL table. The length of string varies, from 0 to 1024
characters. My database version is 5.0.45. I use MyODBC 3.51
driver.

I have tried using varchar(1024) and text column, but
I always find vb error "Application uses a value of the wrong
type for the current operation" when the length of string
is more than 255 chars.

Note : The long string can be stored to the column directly
via mysql query browser.

Could you help me ?

Thanks in advance
Rony