I have moved to new hosting server and now new posts in Cyrillic are being converted into ??? (question marks). MySQL default charset is unicode_general_ci. The only difference is PHP/MySQL version. Old host was running on PHP4/MySQL4, new one is running on PHP5/MySQL5.
Old posts/stories are all OK, but I can't input new ones in Cyrillic alphabet.
Can anyone give a hint on the issue?
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Joined: Apr 06, 2005
Location: Estonia, Tartu
Since your database wasn't utf8 when you created it, you may have mix of collations in your tables and fields.
The quickest fix I found for this was backing up my db, dropping the existing db, creating a new db with the correct collation, and importing the backup (make sure the collation line is correct in the db backup too!)