converting \n\r\t at sql import ?

Hi,

at every export breaks, tabs and spaces were converted to \r, \t and \n - ok.
But when I execute these sql-queries for an import the \r, \t and \n still stay in the textfields, so that the text output of my cms is bad.
What should I do ?

That's odd and should not be true.

Me seems that you're using an old HeidiSQL version. Please verify you're using the latest 3.0 final from http://www.heidisql.com/download.php .

If not so: please provide some detailed information:
- Used HeidiSQL for export AND import ?
- Some sample data which was corrupted by HeidiSQL (1. before corruption, 2. after corruption)

It's 3.0 final.
I used HeidiSQL for both.

I did some tests and got the result, that it depends on the mysql version which is selected for export. For 3.x and 4.0 the error occurs, for 5.1 everything's fine.
So, for me it's no longer a problem, I can use 5.1.

example data:
(origin)
parameter1=value parameter2=value
class=something
(corrupt)
paramter1=value\nparameter2=value\rclass=something