Topic: how to replace character... (Read 731 times)
Just another rainy day
Posts: 1
10 credits Members referred : 0
« on: Oct 13, 2007, 05:02:22 PM »
Hello all,
I'm working on an import script from one db server to another (Ms SQL to MySql). One field is a text field and it contains a "" character, how can I deal with this? I need to split the string up into chunks and that is the "seperator" and I can't get it to work Any suggestions?
Thanks in advance...
R
I am a metal monkey!
Administrator Community Supporter?
Jedai Sword Master
Gender:
Posts: 8272
42619 credits Members referred : 3
« Reply #1 on: Oct 13, 2007, 05:12:15 PM »
This must be a special character which you can represent in php with \ (eg. \n \r \t)
If you just want to import this to mysql, just take the mysqlimport and without opening it put it to mysql.
This problem usually occurs from opening a linux file to notepad.