MySQL db question marks instead of hebrew characters..?

Question

I'm trying to build a shopping cart using PHP & MySQL. my db in MySQL is utf8 and my table in the db is utf8,

How can I use Hebrew characters?

Answer 1

I was able to solve this by doing the following:

1. the db collation has to be utf8_general_ci
2. the collation of the table with hebrew has to be utf8_general_ci
3. in your php connection script put header('Content-Type: text/html; charset=utf-8');
4. in xhtml head tag put <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
5. after selecting the db in the connection script put mysql_query("SET NAMES 'utf8'");