Hi,

I have records in my MySQL database which are in Romanian, where such characters as ă, î, â, ș, ț appear. The database was created with the statement

and, as you'd expect, there's no problem with the Romanian characters (e.g. in the MySQL utility).
However, in PHP generated HTML, I get rogue characters instead of the correct ones after a SELECT... query.

What can I do to get correct characters ?

On the Internet, someone suggested to have a "SET CHARACTER SET utf8;" directive before the query.
Well, it seemed to work for some queries (or the first in a row), but I still get rogue chars in a PHP script where I have multiple subsequent queries.


Thanks,

Mike