Output from database ��

Asked May 10 '16 at 08:20

Active May 10 '16 at 08:20

Viewed 36 times

I have the database filled with some data (added from command line), i setup encoding of the database to utf-8 as well as my website is.

But the output from the database where special chars like "š" etc. is outputted as "�", so what have I done wrong or what should I add? I am siply ECHOing as echo $row['title']; etc.

asked May 10 '16 at 08:20

Kryštof Košut

It is unclear what is your question. provide more information with code. – Shyam Bhimani May 10 '16 at 08:23
Could you try **utf8_decode($row['title']);** to see what you get? – Poiz May 10 '16 at 08:26
Did you mean `utf8_encode($row['title'])` – RiggsFolly May 10 '16 at 08:28
We are guessing that when you added the data from the command line you did not ensure that the data you were inserting was in utf8 format first – RiggsFolly May 10 '16 at 08:30
Thanks utf8_encode works! :-) – Kryštof Košut May 10 '16 at 08:30
1

`utf8_encode` should **not** be your preferred solution. Read the duplicate and **handle UTF-8 all the way through.** – deceze May 10 '16 at 08:42
1

@deceze Is right, that was just a suggestion to identify that your issue was that the load of the data was done incorrectly. Fix the data on the database rather than working around the mistake – RiggsFolly May 10 '16 at 09:04
Black diamonds usually means that you have non-utf8 bytes and failed to establish the connection with mysql correctly (see `mysqli_set_charset`). – Rick James May 10 '16 at 17:39

Output from database ����

0 Answers0

Output from database ��