Thanks. Before committing this, I want to make sure it works.
The strange thing is, UTF8 characters seem to work for me
even without this change; for example, see
http://isaac.ssl.berkeley.edu/test/forum_thread.php?id=56
http://isaac.ssl.berkeley.edu/test/forum_thread.php?id=44#111
Is this because of my MySQL settings?
(note the character_set_system)
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)
-- 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
> boinc_dev@ssl.berkeley.edu
> 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
boinc_dev@ssl.berkeley.edu
http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev
To unsubscribe, visit the above URL and
(near bottom of page) enter your email address.
