One row in the csv exported from MSSQL (separator is , and enclose sign is ' and row separator is {r}{n}
'1','Head Office,'Street Address 5, 6071, California','-','+61 8 93888406','-','+61 8 92262388','[email protected]','1','content/the-company/contact ','2009-04-23 00:00:00','2009-07-08 05:44:41.513000000','1','en-GB'
When importing this via SQLYog everything gets broken. This is because the “fields enclosed by” doesn't seem to work at all.
I solved it by exporting the data like this instead. Because luckily a ; nor a | isn't used anywhere in the text. I use pipe for row separator.
1;Head Office;Street Address 5, 6071, California;-;+61 8 93888406;-;+61 8 92262388;[email protected];1;content/the-company/contact ;2009-04-23 00:00:00;2009-07-08 05:44:41.513000000;1;en-GB|
So if someone'd have a look at that, I'd be really happy! 🙂
What's even more annoying is I have to export in UNICODE in MSSQL to be able to export. But when I import that into SQLYog I get Binary/Image for everything. However, if I open up the files in Notepad++ and save them as UTF-8 and then import, everything works okay. Talk about hazzle! 🙂
Regards, Elrinth
