使用PHP和MySQL进行希伯来语编码

Question

I'm currently writing a php5 web application. It suppose to extract data from the DB and show it in an HTML page. In order to show Hebrew characters, the charset encoding in the HTML is:charset=windows-1255
The application is configured to work with MySQL. I have problems with the Hebrew encoding, it's actually some kind of paradox...
1. When I configure the collation in the DB table to be UTF_bin and the charset UTF-8:
The Hebrew characters that extracted from the db are shown fine, the HTML Hebrew not.
2. When I configure the collation in the DB table to be UTF_bin and the charset windows-1255:
The Hebrew characters that extracted from the db are show are show as random characters, the HTML Hebrew is ok.

Does anyone has an idea how to solve it?
Thanks!

Answer 1

Do you have a simple coding sample/example?

I assume you've..

1) appended the charset on the end of the HTTP Content-Type header too? header('Content-type: text/xhtml; charset=windows-1255'); as well as the tag?

2) using multi byte string functions http://php.net/manual/en/book.mbstring.php or are overloading all string functions http://www.php.net/manual/en/mbstring.overload.php, and/or hebrev() or hebrevc() where required

3) and you're using setlocale() for other localisations http://php.net/manual/en/function.setlocale.php

If you're pulling UTF out of the DB, you may need to use iconv() or similar to translate it to another encoding? http://www.php.net/manual/en/function.iconv.php