• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Problems with character encoding

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Rafael,
I'm just wondering:


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

Is it right? Should it be like this:


Please advise.
[originally posted on jforum.net by onsh76]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
reply
    Bookmark Topic Watch Topic
  • New Topic