MySQL Forums :: Newbie :: How to store long string from VB6 to MySQL database


Advanced Search

How to store long string from VB6 to MySQL database
Posted by: rony good ()
Date: August 19, 2009 08:43AM

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

Options: ReplyQuote


Subject Written By Posted
How to store long string from VB6 to MySQL database rony good 08/19/2009 08:43AM
Re: How to store long string from VB6 to MySQL database Rick James 08/20/2009 10:00AM
Re: How to store long string from VB6 to MySQL database rony good 08/22/2009 03:17AM
Re: How to store long string from VB6 to MySQL database Rick James 08/22/2009 05:28PM
Re: How to store long string from VB6 to MySQL database Rick James 08/22/2009 05:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.