• 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

Internationalization

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I am trying to configure jforum to work with Russian letters and having some problems.

When I post a message I can see Russian letters only in topic. For example here is a page with topics: http://www.jforum.net/forums/show/5.page. So topics are displayed with Russian letters but when I go to body of the message I see questio marks (???). Here is an example of body of a message: http://www.coderanch.com/t/576296

Why is it happening?

What can be done to correct this? I assume the problem when I try to save in to a database but I am not sure.

Thanks!
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
AnotherGuest
?� ???�??�? ��?�?�?��? ?�?� ?�?�?�?�, ?���?��?�?? ?���??�???Ȅ??���?�? ��???Ȅ�?�?? ???� ?�?�??��?��??�, ???� ???�???�?��� ???��???�?Ȅ�??? ��?�?�??��?�?���. ?�???���?� ??? ??��???��� ?? ?��ۄ�??? ��???�?�?�?�.
[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
?�???���?���?��???,

?� ?��܄�?��?�?�� �???���?�?�?� ?���??�??��??�?���?�???�??��?��???���� ???� ?�?�???�?��� ?� ?�??��??? ??�??� �?��?? ?�?�?�?? ???� Fedora Core 5 ?�??�?��?�???���
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I experienced this kind of problem as well.

I can only get it working with mysql 4.0.x - newer versions don't work very well.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rafael,

I installed MySQL 4.0.26 and still experience the same problem.
Do I need to alter the tables?

Also, I people on line say that 4.0.26 version does not support UTF8 character set.

Thanks.
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

AnotherGuest wrote:?�???���?���?��???,

?� ?��܄�?��?�?�� �???���?�?�?� ?���??�??��??�?���?�???�??��?��???���� ???� ?�?�???�?��� ?� ?�??��??? ??�??� �?��?? ?�?�?�?? ???� Fedora Core 5 ?�??�?��?�???���



?�?Ȅ? ��??? ����???��� jforum ?�??�ۄ�?�?���??? ��?�?�??��?�?� �? utf-8 ?� mysql ?? �?���???��� ?�???�?���?� ???�???���???�?�??? ?? ��?�???�?� \WEB-INF\config\jforum-custom.conf

?���???�?�??����

mysql.encoding=&characterEncoding\=utf8
mysql.unicode=&useUnicode\=true



[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
?ل�?�???��� ?�?���???�??,

?�?�?��??�?�?? ?�?� �???���. ?�?�???�??�? ???��??�?���?�?Ȅ�??? ?�???���???��Ą? ?� ?�??�???��ۄ? ����?? ?�???ȄĄ�?��?�?.
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
?�?���?��?��??��??��?� ?�?���???�??,

?�?�?��??�?�?? ?�?� ?�?���?� ?�???�??��?���?�?�! ?Մ??� ?�?���?�?�??��?�?�??.

[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rafael,

As was suggested by Serge to make forum work with Russian letters all is needed is to add these two lines:

mysql.encoding=&characterEncoding\=utf8
mysql.unicode=&useUnicode\=true

to \WEB-INF\config\jforum-custom.conf

Thanks!
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Interesting thing,

I got it working on Windows with MySql 4.0.26 but on Linux - Fedora Core 5 with MySql 4.1.XX I still get question marks.

Is this happening because of MySQL?

Thanks.
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

AnotherGuest wrote:Interesting thing,

I got it working on Windows with MySql 4.0.26 but on Linux - Fedora Core 5 with MySql 4.1.XX I still get question marks.

Is this happening because of MySQL?

Thanks.



Do you create database as this:?

create database jj charset=utf8;
[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hmm,

not sure. Let me check.

Thanks.
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nope, no luck.

As you suggested I created a db with that statement but still see question marks.

Therefore, the problem is in DB. Which version of MySQL are you runing jforum on?

Thanks.
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In one of the posts Rafael mentioned that they were not able to get Cyrillic content working with MySQL 5.XXX. Therefore, I am thinking of reinstalling the DB ��� downgrading from 5.XXX to 4.XXX.

How do I move data? Would it be a bad idea to have two MySQL instances? One that I currently have is use by a webapp.

Thanks.

[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

AnotherGuest wrote:In one of the posts Rafael mentioned that they were not able to get Cyrillic content working with MySQL 5.XXX. Therefore, I am thinking of reinstalling the DB ��� downgrading from 5.XXX to 4.XXX.

How do I move data? Would it be a bad idea to have two MySQL instances? One that I currently have is use by a webapp.

Thanks.



?�?�??��?��? ?�??�ۄ�?��???�?� �??? ?�??�ۄ�?�?� �? 4.1 ???� 5.0.24. utf-8 ?���?�?���?��??? ��?�?�??��?�?���. ??��???���?�?�?��?��?�? ?�?�?� �ۄĄ?�??�?�?� ?���?�??�� ��?�?� ?� �??�???�??�?�?� ?�?���???�?��� (�� ???�??�? ?��?��� ?�?Ȅ? ��?��?��?�)
��?�?� ����?? �???�܄??�?� ?�?�?�?���� ?�?���???��?�???� ???� ???�?���. ?ل�?�???�?Ȅ�???�?� ��?�?�???���?���΄?�? ?�??��?�??�� ???� ��?�?�??��?�?��� �ۄĄ?�??�?�??. ?�???�???�??? �?��?? �??�?�?��?��???�?� ?�??�???Ȅ�?�???�???�? ?�?�??��?��??�.

�� ???�??�? WinXp.

[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
?�?�?��??�?�?? ?�?� ?�???�??��?���?�?�.

?�??��???�?� ����?? ?�?�?�?? ?? ?�?�??��?��??� ��???�?�.

?� ???�??�? ???� WinXp ��???�?� ��?�?�??��?�?��� ??? ???� 4.0.

?Ԅ�?��� ��?�?�?�?��?���΄?�? ��???�?�.

?? ???�?� ???�?���� ?��܄�� ?���???�?�?�???� ?? ?�?�??��?��??� ???� ?�?��� ???�???Ȅ??�?

[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

AnotherGuest wrote:?�?�?��??�?�?? ?�?� ?�???�??��?���?�?�.

?�??��???�?� ����?? ?�?�?�?? ?? ?�?�??��?��??� ��???�?�.

?� ???�??�? ???� WinXp ��???�?� ��?�?�??��?�?��� ??? ???� 4.0.

?Ԅ�?��� ��?�?�?�?��?���΄?�? ��???�?�.

?? ???�?� ???�?���� ?��܄�� ?���???�?�?�???� ?? ?�?�??��?��??� ???� ?�?��� ???�???Ȅ??�?



?� ����?? ???� ?�?�??��?��??� ??��?�?�?��� mysql ?�???�???�?� status?
�� ???�??�?

mysql> status
--------------
C:\opt\MySQL5.0\bin\mysql.exe Ver 14.12 Distrib 5.0.24, for Win32 (ia32)

Connection id: 28
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.0.24-community-nt
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 2 hours 51 min 28 sec
[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here is what I have:




?� ?�???�?�???��? ����?? latin1 - ?���???�?�?�???�.
?Մ� ?�???�?���?� ?�?�?� �?��?? ?�??���?�???���?

Thanks.
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
?�??��? ???� WinXp ?�???�?�?��???�?���



?� ??�??� ��?�?�??��?�?��� ???��?�???�?Ȅ�???
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

AnotherGuest wrote:?�??��? ???� WinXp ?�???�?�?��???�?���



?� ??�??� ��?�?�??��?�?��� ???��?�???�?Ȅ�???



???�?��� ?? ??��???�?� ?�???�??�?����? :
�� ???�??�? ???�?�?�?�?�� ?�???���?���??�܄� ??�܄??�?�?? ???��� ?�?�?� �?��?? ??��?�?���?���

[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
?�??��??��??,

?���?��� �???���?���� ��???�?�.


[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

AnotherGuest wrote:?� ?�???�?�???��? ����?? latin1 - ?���???�?�?�???�.
?Մ� ?�???�?���?� ?�?�?� �?��?? ?�??���?�???���?

Thanks.



?�???�?��� ?�?�???�???��� ?? /etc/my.ini default-character-set=latin1 ???� default-character-set=utf8, ?��??�?� ???� ???���?� ��?�?? ?��?���. ?? ?��??�?� ???���, ��?? ?���??�?��?? ?�???�?�???��� ?? ?�?�?�?���?? ��?�?�?�?�?�.

[originally posted on jforum.net by VVD]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
???�?�?�?�?��?!
?�???���???��Ą?, ?�??�???���?�?? ?��??�?� ?�???�?���...
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
��??,
�� ???�??�? ???��� ��?�???�?� /etc/my.ini
:?:

?��?��� ��???Ȅ�?�?? my.cnf


[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
??�ĄĄĄ�
�??�?�?�?�?�, ??�??� ?�?���?�?�??��?�?�?? ???� ?�?�??��?��??� �? ??�Ą??���?�??? ?��?���??
?� ?�?���?�?�???�?��???�?� .conf ��?�???� ???� ?�?�??��?��? ?�???��΄?��?��� �? Win ?�?�?����??��??�� ?� ??�??� �?��?�?�?? ???��???�?Ȅ�???

?�?�?��??�?�?? ?�?� ?�???���!
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

AnotherGuest wrote:??�ĄĄĄ�
�??�?�?�?�?�, ??�??� ?�?���?�?�??��?�?�?? ???� ?�?�??��?��??� �? ??�Ą??���?�??? ?��?���??
?� ?�?���?�?�???�?��???�?� .conf ��?�???� ???� ?�?�??��?��? ?�???��΄?��?��� �? Win ?�?�?����??��??�� ?� ??�??� �?��?�?�?? ???��???�?Ȅ�???

?�?�?��??�?�?? ?�?� ?�???���!



?�???�?��� ?��܄�� ???�?�?��?��?� ?���?���?�???� how-to ???� ?�???�?�??�??�??? ?�?�?� ?�?��?��?�???��� ��?�?�??��?���� mysql ???� ?�?�??��?��??� �? ???���?�???�?Ȅ�??��???� �??��?�?�???� (utf-8)?


[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
?? ?�??��?�??�� ?��� ?� ???���?
?� ��??��?�?� �?��?? ??��?���?� �??�?�?�?���� ��???Ȅ�?�?? ?�?�?� ???��܄�??? ??��?�???�???� ???� ???� ����?? ???� ��???���?�?���

?�??��?��?� ?�???����?
[originally posted on jforum.net by AnotherGuest]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

AnotherGuest wrote:?? ?�??��?�??�� ?��� ?� ???���?
?� ��??��?�?� �?��?? ??��?���?� �??�?�?�?���� ��???Ȅ�?�?? ?�?�?� ???��܄�??? ??��?�???�???� ???� ???� ����?? ???� ��???���?�?���

?�??��?��?� ?�???����?



�??�?��??�?�?? ?�?�?���?�?�?�???�?�???�?� ??? ?�???�?� - ???���
???�??�? ?�?�?��� �??? ?���???�?��� - http://sourceforge.net/projects/riverock
[originally posted on jforum.net by Serge Maslyukov]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

AnotherGuest wrote:��??,
�� ???�??�? ???��� ��?�???�?� /etc/my.ini
:?:

?��?��� ��???Ȅ�?�?? my.cnf


?��??�?� ?�??��?��?���� ???�?? ?�?? ??�Ą??���?Ȅ�, ��?? ��?�?? �??�?�?�?�??? ?�?�?�?�?� ��?�???Ȅ� ?� ?? ?�?�?�??? ?�??�ۄ??�?�?� ??? ?�??�???Ȅ�?��?��� ?? ?�?���?��?��???� ?�???��?�???.
[originally posted on jforum.net by VVD]
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!