Every once in a while I run into this problem and finally decided to consult the experts. :) I insert foreign characters (Czech letters) into my MySQL database and see them there. They look fine. But when I try to retrieve them using PHP they come out with question marks on my website. Can someone tell me how to fix this? I use the charset utf-8 on the website (the characters on my website are all Czech) and I tried changing the Collation of the columns to different charsets. Such as utf-czech_ci or utf-general_ci and they still come out with question marks. I'm not sure if this is a MySQL problem or a PHP problem or an HTML problem, but I'm hoping someone else might know. Thanks.
Pado
0
Light Poster
Recommended Answers
Jump to PostSounds to me like an HTML problem, if you can see the characters correctly in, say, phpadmin, that would mean that the database is storing and retrieving them correctly.
Your HTML code has to tell the browser which character set it is using, a line in the <head> section …
All 4 Replies
Simon Tite
15
Light Poster
aquilax
7
Junior Poster in Training
d5e5
109
Master Poster
Pado
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.