From: Ali, Saqib (docbook.xmlgmail.com)
Date: Mon Nov 03 2008 - 16:02:48 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I exported a large data set from from Microsoft SQL server in CSV
format. However whenever I try to import that data to a a mySQL server
running on Linux, it adds a space between each character in each
field.

Essentially:
Saqib Ali
becomes
S a q i b A l i

I have tried to use the dos2unix cmd on linux, but that didn't help either.

I am using the following SQL to import the data:
LOAD DATA LOCAL INFILE '/home/saqib/data.csv' INTO TABLE apps FIELDS
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Any thoughts?

saqib
http://doctrina.wordpress.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]