Json - Mysql Charset Problem

Question

I convert my php array to json using json_encode, Than I record this json data to my database .While json_encode encodes my data , It also converts strings to utf8 , this changes special characters to something like '/u011f' or '/u0131' . But when I write this converted data to mysql database , Backslashes are disappearing in field, so when I get this data back , html can not render characters correctly.

What should I do to keep backslashes.

Make sure you're always using mysql_real_escape_string or pdo/mysqli prepared statements, actually. This is really important to avoid SQL injection attacks as well as other problems. — JAL
– JAL, Commented Jul 1, 2010 at 19:59

MarkD · Accepted Answer · 2010-07-01 17:12:01Z

2

Use mysql_real_escape_string to escape the string before inserting it into the database.

escapedJSON = mysql_real_escape_string(jsonEncodedString);

answered Jul 1, 2010 at 17:12

MarkD

4,9825 gold badges41 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Emre Yazici · Accepted Answer · 2010-07-01 17:11:38Z

1

Use mysql_real_escape_string() to escape string data before sending database so that mysql does not treat backslashes as an escape character.

answered Jul 1, 2010 at 17:11

Emre Yazici

10.2k6 gold badges50 silver badges56 bronze badges

Collectives™ on Stack Overflow

Json - Mysql Charset Problem

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related