utf-8 troubles

Question

Hi, i have a dynamic site with php/mysql. I am testing on my
local machine running WAMP 1.7.0. For MYSQL, i have defined the
charset to UTF-8 Unicode, collation utf8_general_ci. 
In my admin section of the website I have a form to add
records into the database. The page has utf-8 charset defined in
the meta tag. 
Now the problem - when i add text into my database (for
example into a varchar field in a table) from this webpage and have
a look at the data in the database through Navicat i can see that
the text is broken - it does not display our Slovak characters
right. Instead of the Slovak characters I get something like this
("Ä¾Å¡Ä&#141;Å¥Å¾Ã½Ã¡").

What am i doing wrong? Am I supposed to set the UTF-8 also in
Apache somewhere or Apache has nothing to do with it? What am I
missing here?

metalllus · Accepted Answer

SOLUTION: I entered these commands into mysql console:

SET CHARACTER SET UTF8
SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;
SET NAMES = 'utf8';

Everything works just fine since then.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded