Bug #6393 MSSQL 2K & Linked MySQL Server fail with varchar(<4)
Submitted: 3 Nov 2004 0:11 Modified: 11 May 2006 15:22
Reporter: Jorge del Conde Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version: OS:Microsoft Windows (Win32)
Assigned to: CPU Architecture:Any

[3 Nov 2004 0:11] Jorge del Conde
Description:
We have a problem with mysql and varchars of less than 4 chars when using a linked server through MyODBC in MSSQL 2K. MS Access works as expected. 

How to repeat:

in mysql:

create table ctest ( c1 varchar(2), c2 varchar(20) ); insert into ctest values ('a','b'),('c','d');

in sql2k, create a linked server using myodbc and then run:

select * from ctest

.. that will reproduce this error.
[11 May 2006 15:22] Miguel Solorzano
Thank you for the bug report. I was unable to repeat:

Full Connect(Default)

	Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3

	Successfully connected to DSN 'db2'.
SQLExecDirect:
				In:				hstmt = 0x003B1930, szSqlStr = "select * from ctest", 
										cbSqlStr = -3
				Return:	SQL_SUCCESS=0

Get Data All:
"c1", "c2"
"a", "b"
"c", "d"
2 rows fetched from 2 columns.