MySQL Bugs: #49131: Text field truncated to 255 chars in Ms-Access 2007truncate

Bug #49131	Text field truncated to 255 chars in Ms-Access 2007truncate
Submitted:	26 Nov 2009 10:19	Modified:	27 Nov 2009 15:27
Reporter:	Jorrit de Jong	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	5.01.06.00	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	text, truncated, windows, windows xp

Description:
Textfield in MySql  servertable linked via ODBC
Any text visible in Access has max. 255 chars. 
When copying data into memo field in Access only 255 chars are transported.

How to repeat:
See above

Hi Jorrit and thanks for your report.

Unfortunately, I can not repeat it.
Environment: Win2K8SE x64, Access2007 Pro, c/ODBC 5.1.6GA with properly set System DNS (as in our manual). Remote MySQL server 5.1.31log running on OpenSolaris (lates) x64.

Test:
mysql> show create table bug49131\G
*************************** 1. row ***************************
       Table: bug49131
Create Table: CREATE TABLE `bug49131` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `TxtField` text,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

Open Access, External Data/More/ODBC Database, pick DSN, pick table to link, display table in Access, paste text (~42000 characters) into text field, select from that table (file attached). All works as expected.

Much more than 255 characters showing in Access2007

Attachment: Bug49131.jpg (image/jpeg, text), 169.03 KiB.

mysql -u** -p -h** test < bug 49131-input.txt > bug49131-output.txt

Attachment: bug49131-output.zip (application/x-zip, text), 11.45 KiB.

Problem is that the MySQL table is created by another package. (Chronoform) and I already have checked the tables itself and they look fine. But I can't get it into Access loaded.

Also I have great difficulties in installing latest version of the ODBC driver. I am not able to compile the DLL's. Can I download them somewhere?

Example why I CAN repeat the problem.

Attachment: Table bug49131 created.doc (application/msword, text), 91.00 KiB.

Hi Jorrit.

I see you just love MS SW but it would be much better to extract table creation statements in form suitable for me to run on MySQL server (mysqldump, "SHOW CREATE TABLE ..." etc).

I have no idea what's happening on your box but checking ODBC tracing might help you find problem in mapping. Or, you might even have found another bug in Access.

Joke aside, please do not attach images unless absolutely necessary and, even then, do not use proprietary SW to stuff images in.

Problem is solved. Pfff.

I installed the myodbc5.dll files again and changed options in the ODBC connection.
By newly connecting the MySql tables to Access, the field are now MEMO instead of TEXT.

Jorrit, main thing is problem's solved.