Take the 2-minute tour ×  I'm having an issue that i believe is
related to unicode text. When the user enters a string that has
the unicode bullet character, mysql is not able to save that
field (the rest of the update query works though). Here's how
i've been trying to deal with it.  $str = "· Close up the
server";  $str = preg_replace("\u2022", "&bull;", $str);
...however this is still not working.  share|improve this
question Did you try $str = preg_replace("·", "&bull;", $str); ?
–  Vladimir Dec 20 '12 at 17:04 Did you try $str =
htmlentities($str)? –  GolezTrol Dec 20 '12 at 17:05 @Vladimir
has a point –  samayo Dec 20 '12 at 17:05 Tell us about your
database's collation/encoding. Suggested reading:
joelonsoftware.com/articles/Unicode.html –  ficuscr Dec 20 '12
at 17:06 Table encoding: cp1252 Western European (latin 1)
Collation: latin1_swedish_ci –  drschultz Dec 20 '12 at 17:15  2
Answers 2  up vote 3 down vote accepted  So many things can go
wrong here, because database, form submits and source code