• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Problems with character encoding

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • 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]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!