MySQL Bugs: #42269: "carriage return" in TEXT field splits the data in Access tables

Bug #42269	"carriage return" in TEXT field splits the data in Access tables
Submitted:	22 Jan 2009 13:16	Modified:	2 Feb 2009 8:02
Reporter:	Regnier fabrice	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	5.1.5	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
hello,

Odbc Mysql Connector: 5.1.5
Access 2000 on windows xp SP3
Mysql server 5.0.32 on linux server

How to repeat:
I have a mysql table with TEXT field. In this field, i have recorded 3 lines. Let's say:
Line 1
Line 2
Line 3

At each end of line, i entered a carriage return.
I can see perfectly my 3 lines with phpMyadmin.

When i link this table in Access2000, the TEXT type has become MEMO, ok. But i can see only the first line.

regards,

fabrice regnier

Fabrice, thanks for your report.

Please do mysqldump of database in question (it should contain just problematic table and data but you should be able to repeat the problem on it) so I can import it and test. Also, please paste output of "SHOW VARIABLES LIKE %char%".
What are the options in DSN? Is it System or User DSN?

Ok, what about output of "SHOW VARIABLES LIKE %char%"?

hi,

>Please do mysqldump of database in question (it should contain just
>problematic table and data but you should be able to repeat the problem
>on it) so I can import it and test. 
see on attached files.

>Also, please paste output of "SHOW
>VARIABLES LIKE %char%".

mysql> SHOW VARIABLES like '%char%';

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

>Is it System or User DSN?
It is neither a system, nor a user dsn but it is a file DSN which is stored on the network (linux server).

>What are the options in DSN? 
gdslinux:/DSN# cat gds_consult.dsn
[ODBC]
DRIVER=MySQL ODBC 5.1 Driver
UID=my_uid
SERVER=192.168.99.1
PORT=0
OPTION=0
DATABASE=my_base

regards,

f.

Regnier,
I'm not sure exactly what you expect to happen here. There's multiple lines of data. To deal with this in Access, you can expand the height of the row or when editing the text field (click in it), press the up and down arrow keys to see the other lines.

*blush*

I'm a donkey.

There is no bug at all. Actualy, the multi lines are present. I just had to expand the height of the row in access.

Please, please, close that bug very fast ;)

apology for wasted time,

f.

Fabrice, no need to apologize. Main thing is code works.

Thanks for your interest in MySQL.