I have an euro sign in the database. When I want to print it out on my website it is showing a question mark.
It's from text field --> database --> website.
Asked
Active
Viewed 4,019 times
0
-
11You're not using UTF-8 everywhere, but you haven't remotely provided enough information. – Matt Ball Aug 14 '12 at 21:17
-
possible duplicate of http://stackoverflow.com/questions/6810587/euro-sign-not-showing-on-site – jeremy Aug 14 '12 at 21:19
-
http://www.joelonsoftware.com/articles/Unicode.html – WayneC Aug 14 '12 at 21:20
-
aside from the DB you may need to look at the encoding header of your HTML output. – David Chan Aug 14 '12 at 21:34
-
@MattBall its a bit late, but thank you :) it makes sense now so many years later. – JochemQuery Nov 29 '18 at 20:07
1 Answers
1
Your database is not UTF-8.
This may help:
mysqli_query($conn, "SET NAMES utf8");
Or this query:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8
Also, include this <meta /> tag in the <head> of your HTML page:
<meta charset="UTF-8" />
uınbɐɥs
- 7,236
- 5
- 26
- 42
-
1best to do both, also ensure the browser interprets the sent html also as UTF-8, therefore you can send an http header and/or add a html head field for the content type – DesertEagle Aug 14 '12 at 21:29