I just upgraded to Moodle 1.8.2 and I still cannot enter Hebrew. The behavior is exactly the same as before.
Let me summarize again the behavior:
In the editor I enter Hebrew characters. In the code view I see the Hebrew characters. After saving changes the results are ??????. If I edit again I see the ????? in both the editor and in the code viewer.
I tried also the new feature: Highlight the Hebrew letters in the editor and choose he from the language drop down. The code shows a span tag with lang he. When saved still showing ?????.
What else can I do?
A reminder about what I see in the database:
Server - UNIX
Language - English
Charcter set: MySQL charset: UTF-8 Unicode (utf8)
Collation - UFT8 _unicode_ci
The list of database shows the following:
The collation of all tables show: latin1_swedish_ci (this is very strange)
|MyISAM||Default engine as of MySQL 3.23 with great performance|
|MEMORY||Hash based, stored in memory, useful for temporary tables|
|InnoDB||Supports transactions, row-level locking, and foreign keys|
|BerkeleyDB||Supports transactions and page-level locking|
|BLACKHOLE||/dev/null storage engine (anything you write to it disappears)|
|EXAMPLE||Example storage engine|
|ARCHIVE||Archive storage engine|
|CSV||CSV storage engine|
|ndbcluster||Clustered, fault-tolerant, memory-based tables|
|FEDERATED||Federated MySQL storage engine|
|MRG_MYISAM||Collection of identical MyISAM tables|
|ISAM||Obsolete storage engine|