MySQL Bugs: #12290: Text field types are returned as VarChar

Bug #12290	Text field types are returned as VarChar
Submitted:	31 Jul 2005 12:48	Modified:	30 May 2013 7:39
Reporter:	Rod Kelynack	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	3.51.11	OS:	Windows (XP Pro)
Assigned to:		CPU Architecture:	Any

Description:
Using MySQL/ODBC 3.51.11 and VB6/ADO2.5

Trying to copy data from one database to another (MySQL/MySQL - application to data warehouse) all text fields are typed as varchar  (ie rs.type = 200)  

Problem is that when copying large fields (>2k) I get an error (multiple oledb errors) and program crashes.

Also having problems with backslashes in the data as well.

And time fields returning as dates.

Any help would be appreciated.

Please do not tell me to use MySQL browser or such like as this program has to get data from many other data sources including 4Discs (French data engine).

Plus the data is not simply "copied" but manipulated

Have classified this as S1 because my program does not work when accessing text fields  and there is a lot of them in the application database (not my design). My "workaround" is to ignore all text fields - not want the customer wants as a final solution. Every else (except for time fields) works well and program runs quickly (1M record db updated in 10 mins).

How to repeat:
write some VB6 code to insert data into a text field - no go if data >2000 chars

Hi

Can you please provide us with a test-case that reproduces this problem ?

Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.