distal-attribute
distal-attribute
distal-attribute
distal-attribute

converting \n\r\t at sql import ?

User, date Message
Written by robsteinde
7 years ago
Category: Import/Export
5 posts since Tue, 22 May 07
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 ?
Written by ansgar
7 years ago
4936 posts since Fri, 07 Apr 06
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)
Written by robsteinde
7 years ago
5 posts since Tue, 22 May 07
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
 

Please login to leave a reply, or register at first.