Thanks, and I'm sorry, I don't know what to say because my knowledge of MySQL is small.
I confirm that cyrillic works in test project. I wrote to developers of russian projects (OPTIMA@Home - http://boinc.isa.ru/dcsdg/, SAT@Home - http://sat.isa.ru/pdsat/) where was this problem. May be they can comment this. But they fixed the problem using some of the scripts below (for forum and private messages tables). --- Nikolay 19 ноября 2011, 00:12 от David Anderson <[email protected]>: > I'm confused, because on our server, without the modifications below, > we're able to create message board postings with various non-ASCII characters, > including cyrillic, and they display correctly. > See, for example: > http://isaac.ssl.berkeley.edu/test/forum_thread.php?id=57#132 > > Our MySQL version: > Server version: 5.5.14 MySQL Community Server (GPL) > > Character set info: > mysql> show variables like 'character_set%'; > *************************** 1. row *************************** > Variable_name: character_set_client > Value: latin1 > *************************** 2. row *************************** > Variable_name: character_set_connection > Value: latin1 > *************************** 3. row *************************** > Variable_name: character_set_database > Value: latin1 > *************************** 4. row *************************** > Variable_name: character_set_filesystem > Value: binary > *************************** 5. row *************************** > Variable_name: character_set_results > Value: latin1 > *************************** 6. row *************************** > Variable_name: character_set_server > Value: latin1 > *************************** 7. row *************************** > Variable_name: character_set_system > Value: utf8 > *************************** 8. row *************************** > Variable_name: character_sets_dir > Value: /usr/share/mysql/charsets/ > 8 rows in set (0.00 sec) > > Anyway, if the problem can be fixed without changing the BOINC code > (e.g., by upgrading to the current MySQL) > I'd rather do it that way. > > -- David > > On 13-Nov-2011 10:48 AM, Nikolay Saharov wrote: > > Hi, > > > > There is a problem with encoding in the BOINC database for forum and private > > messages. > > > > When users write their messages on the native languages (for example in > > Russian, in cyrillic charset), these messages are shown as question marks > > (?????). > > > > The problem is because of BOINC DB tables are non-UTF8 encoded by default. > > > > > > There is a small patch ;-) > > > > alter database boinc_db default character set = utf8; > > > > alter table user convert to character set utf8; alter table team convert to > > character set utf8; alter table profile convert to character set utf8; alter > > table category convert to character set utf8; alter table forum convert to > > character set utf8; alter table thread convert to character set utf8; alter > > table post convert to character set utf8; alter table private_messages > > convert to character set utf8; alter table friend convert to character set > > utf8; > > > > > > May be there are other tables too. > > > > --- Nikolay > > > > _______________________________________________ boinc_dev mailing list > > [email protected] > > http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev To unsubscribe, > > visit the above URL and (near bottom of page) enter your email address. > -- _______________________________________________ boinc_dev mailing list [email protected] http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev To unsubscribe, visit the above URL and (near bottom of page) enter your email address.
