Issue INSERTing control/backslash characters using MySQLLoader

Issue INSERTing control/backslash characters using MySQLLoader

Postby 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
Posts: 6
Joined: Mon 21 Nov 2005 12:53

Postby 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.

Return to dotConnect for MySQL