Trouble making mySQL dump

[Anon]

Hello.
I've experienced some problems when I insert text from a textarea copied from e.g. Word.

When the word document have characters as:
’
–
”

these will be insert into the table like this:
’
–
”

When I use phpMyAdmin to make a sql-file backup of the tabels, I always get an error when restoring the phpMyAdmin sql file because of the above tags.

How do I make a replace function so I can be sure that all the tags thats gives me trouble, is replaced with a non-trouble tag.

/lars

[Anon]

When reading from a Form field (like a textarea) PHP automatically escapes those characters

' becomes \' etc.

this allows them to be inserted directly into the database. Print out your form field and take a look.

However, when they are read out of the database (into your backup) these characters are not escaped. So when being re-inserted into the database they cause problems.

There is a function called addslashes() that will automatically escape all these characters for you.

[Anon]

Well, it wasn't exactly what I ment. Some characters it makes to HTML-coding. When ever it uses a # I get an error when restoring. I've tried to insert it like this: # - but it doesn't help. Same error, same place.

[Anon]

Well,
One simple solution is to use escaped quotation in your Mysql statement(either insert or update). that is,
UPDATE tableName SET key = \"$value\";
yes, magic_quotes_gpc is turned on to make you worry about one thing less.

Lars Skjoldby wrote:

Hello.
I've experienced some problems when I insert text from a textarea copied from e.g. Word.

When the word document have characters as:
’
–
”

these will be insert into the table like this:
’
–
”

When I use phpMyAdmin to make a sql-file backup of the tabels, I always get an error when restoring the phpMyAdmin sql file because of the above tags.

How do I make a replace function so I can be sure that all the tags thats gives me trouble, is replaced with a non-trouble tag.

/lars