Special Characters from MySQL after using mysqli_real_escape_string

Question

I'm using mysqli_real_escape_string function to avoid sql hacking issues but when I fetch that data from mysql using php, ', " & ’ characters are shown as a question mark sign (�) in output. I'm using

<meta charset="utf-8">

Any suggestions would be appreciated.

you can get help from above link – Awlad Liton Dec 26 '13 at 18:11 — Awlad Liton, Dec 26 '13 at 18:11

score 2 · Accepted Answer · answered Dec 26 '13 at 18:10

2

You can try this:

mysqli->set_charset("utf8");

or

query_query("SET NAMES utf8");

answered Dec 26 '13 at 18:10

Awlad Liton

9,366
2
27
53

Should I add this while insertion or selection ?? – Nandla Dec 26 '13 at 18:28
you can use this before any query – Awlad Liton Dec 27 '13 at 04:01
you need to run this query first – Awlad Liton Dec 27 '13 at 05:40

Special Characters from MySQL after using mysqli_real_escape_string

1 Answers1