Problems with character encoding

[Migrated From Jforum.net]

Hi there,

I've just installed jforum.
The following general parameters have been chosen:
Language: ru_RU
Encoding: UTF-8

My database server is mysql5.0.22, the forum db has been created with the following encoding settings:
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |

I was able to assign the forum title in Russian, it was showing the value properly. However, when I began creating categories in russian, then I've got ??? characters.

I've checked the db content to verify if it was written as UTF-8, it looks like it is not (See the hint from mySQL team for non-latin character troubleshooting: http://dev.mysql.com/doc/refman/5.0/en/cjk-faq-question-marks.html
[url]). Per the supplied link I do believe that: "... problem converting a particular character from your client character set to the target character set." Is that right?

Will you please help me to resolve this issue?
Appreciate for your assistance in advance.

onsh76

[originally posted on jforum.net by onsh76]

[Migrated From Jforum.net]

Hi Rafael,
I'm just wondering:

database.connection.string=jdbc\:mysql\://${database.connection.host}\:${database.connection.port}/${database.connection.dbname}?user\=${database.connection.username}&password\=${database.connection.password}&autoReconnect\=true${mysql.unicode}${mysql.encoding}&useNewIO\=false&zeroDateTimeBehavior\=convertToNull&useServerPrepStmts\=false

The above configuration string for mysql database contains the encoding as following:

${mysql.unicode}${mysql.encoding}

Is it right? Should it be like this:

&${mysql.unicode}\=${mysql.encoding}

Please advise.
[originally posted on jforum.net by onsh76]

[Migrated From Jforum.net]

The right is the first one (without the = sign)

That's because it's concatenation of values, which are made with values set individually in the same file.

Rafael
[originally posted on jforum.net by Rafael Steil]