Hebrew characters display as question marks in the database fields

[egurevich]

Hello.
I am using Dadabik 4.2 and MySQL database 5. There are fields in the database that are written in Hebrew and not in English. In the database itself everything looks fine. However when Dadabik reads them and displays that all get displayed as question marks (???????). The encoding that is used in the database is the standard Hebrew encoding windows-1255 which is displayed by all browsers.

All other data from the database that's in English or numbers gets displayed correctly. It also sorts correctly, so it seems that internally Dadabik recognizes the different Hebrew characters that they are different, but just displays them as numbers.

Does anyone know where the glitch might be and if there is some encoding setting I need to change somewhere in Dadabik or which code to change?

Thanks
Wli

 

[egurevich]

I just found this piece of code in another post.

Author: spuri (84.21.23.---)
Date: 12-30-08 01:10

common_start.php

$conn = connect_db($host, $user, $pass, $db_name);
//add this line
@mysql_query('SET NAMES utf8'); @mysql_query('SET CHARACTER SET utf8');
// display will be okay but saving fails, i got ? instead of special characters


I am still having a problem with search. It doesn't seem to search for the Hebrew characters I type in. And it doesn't write the data to the database.

Help.
Thanks
Eli