Issue INSERTing control/backslash characters using MySQLLoader

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Stevod
Posts: 6
Joined: Mon 21 Nov 2005 12:53

Issue INSERTing control/backslash characters using MySQLLoader

Post by Stevod » Mon 21 Nov 2005 13:01

I am using mySQLLoader to insert into a VARCHAR(45) column in MySQL.

Using explicit INSERTS into MySQL, I can insert strings containing either control characters (e.g. tabs) or containing backslashes. (Note that MySQL 5.0 is started using the NO_BACKSLASH_ESCAPES option).

However, when I use MySQL loader, a tab character or a backslash character always seems to cause an exception, saying that the data is too long to fit into the column.

Is MySQLDirect.NET sensistive to these characters, and if so, please, please could the software be updated to reflect the latest capabilities of MySQL 5.0.

Many thanks
Stevod

Serious

Post by Serious » Tue 22 Nov 2005 13:21

We tested MySqlLoader class and found no problems with inserting backslash or tab characters into MySQL 5.0 database (with default settings in my.ini config file).

Please send us small test project if possible to reproduce the problem; it is desirable to use 'test' schema objects, otherwise include definition of your own database objects. Do not use third party components.

Post Reply