Devart Forums

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

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.