Hebrew as question marks

[mysql]

Hi,

I'm trying to insert hebrew characters like עברית inside an full utf8 table, using MySQL Query or a unicode served html form, and I am getting only recorded question marks instead of hebrew.


MySQL Query and 'mysql' binary client return same results:

mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
+--------------------------+----------------------------------+

Running MySQL 5.1.12 on FreeBSD6.1 and OSX 10.4 boxes with latest MySQL Tools for OSX and mysql-ruby 2.7.1 bindings.

What could be wrong ?



Edited 1 time(s). Last edit at 12/06/2006 06:24AM by mysql.