Missing SERBIAN(CROATIAN) characters...

[misxa]

Hello guys.

I installed MySQL 5 and PHP 5.1. I created a test database with a single table. I entered a few test data containing serbian latin characters like ŠĐČĆŽšđčćž, I can see them regularly in MySQLFront, but can't force PHP script to display them the way they should look...

I tried many encodings on MySQL and PHP, but no hope (latin2, utf-8...).

HELP!

[MarkR]

You should construct your application in UTF-8 correctly. In practice this means:

1. Create your tables in MySQL in UTF-8
2. When connecting to MySQL, ensure that your connection encoding is UTF-8, with the command "SET NAMES utf8" - people often get this wrong.
3. As all internal structures in PHP will now be in UTF-8, ensure that your .php files themselves (as well as includes) are saved using this encoding. This applies equally to other files used by PHP e.g. Smarty templates.
4. Send appropriate Content-type: headers on each page; ensure that you don't have conflicting <meta http-equiv tags or anything.
5. When sending email, send the appropriate MIME headers to set the encoding
6. When interfacing with any third party system, be mindful of what encoding you're using.

And everything should just work.

Mark

[misxa]

This didn't work:

mysql_query("SET NAMES 'utf8'");

But this EVENTUALLY worked 🙂:

mysql_query("SET NAMES 'utf8'", $conn);

Thanks for your precious help!