Date |Thu, 26 Jul 2001 14:32:48 -0400
>From |"Nikhil Goyal" <[EMAIL PROTECTED]>
Hello!
NG> Hello people,
NG> I've a mysql database which is quite large and I needed to create a backup
NG> for it, which I can use offline in MS Access or such. I've tried using
NG> MyODBC, but one strange problem has come up. Certain fields (defined as
NG> TEXT) in my databast have multiple lines in them, separated by CRLF pairs.
NG> And when I inport using MyODBC, it only imports the first like of each
NG> field. Which means:
NG> If the initial database row was
NG> field1 field2
NG> x1 this is line1<CR><LF>this is line 2
NG> x2 something<CR><LF>more
NG> the import into access looks like this
NG> filed1 field2
NG> x1 this is line1
NG> x2 something
NG> does anybody have any suggestions on what I should do? Any help is
NG> appreciated
NG> Nikhil Goyal
You need to convert all non-printable symbols to escape sequence before
insert. It's can help.
___________________________________________________________________
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Grigory Bakunov <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
