aspose file tools*
The moose likes JForum and the fly likes Internationalization Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Internationalization" Watch "Internationalization" New topic
Author

Internationalization

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
AnotherGuest
?� ???�??�? ��?�?�?��? ?�?� ?�?�?�?�, ?���?��?�?? ?���??�???Ȅ??���?�? ��???Ȅ�?�?? ???� ?�?�??��?��??�, ???� ???�???�?��� ???��???�?Ȅ�??? ��?�?�??��?�?���. ?�???���?� ??? ??��???��� ?? ?��ۄ�??? ��???�?�?�?�.
[originally posted on jforum.net by onsh76]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
?�???���?���?��???,

?� ?��܄�?��?�?�� �???���?�?�?� ?���??�??��??�?���?�???�??��?��???���� ???� ?�?�???�?��� ?� ?�??��??? ??�??� �?��?? ?�?�?�?? ???� Fedora Core 5 ?�??�?��?�???���
[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
?ل�?�???��� ?�?���???�??,

?�?�?��??�?�?? ?�?� �???���. ?�?�???�??�? ???��??�?���?�?Ȅ�??? ?�???���???��Ą? ?� ?�??�???��ۄ? ����?? ?�???ȄĄ�?��?�?.
[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
?�?���?��?��??��??��?� ?�?���???�??,

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

[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
Hmm,

not sure. Let me check.

Thanks.
[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
?�?�?��??�?�?? ?�?� ?�???�??��?���?�?�.

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

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

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

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

[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
Here is what I have:




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

Thanks.
[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
?�??��? ???� WinXp ?�???�?�?��???�?���



?� ??�??� ��?�?�??��?�?��� ???��?�???�?Ȅ�???
[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
AnotherGuest wrote:?�??��? ???� WinXp ?�???�?�?��???�?���



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


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

[originally posted on jforum.net by Serge Maslyukov]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
?�??��??��??,

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


[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
???�?�?�?�?��?!
?�???���???��Ą?, ?�??�???���?�?? ?��??�?� ?�???�?���...
[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
��??,
�� ???�??�? ???��� ��?�???�?� /etc/my.ini
:?:

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


[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
??�ĄĄĄ�
�??�?�?�?�?�, ??�??� ?�?���?�?�??��?�?�?? ???� ?�?�??��?��??� �? ??�Ą??���?�??? ?��?���??
?� ?�?���?�?�???�?��???�?� .conf ��?�???� ???� ?�?�??��?��? ?�???��΄?��?��� �? Win ?�?�?����??��??�� ?� ??�??� �?��?�?�?? ???��???�?Ȅ�???

?�?�?��??�?�?? ?�?� ?�???���!
[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
AnotherGuest wrote:??�ĄĄĄ�
�??�?�?�?�?�, ??�??� ?�?���?�?�??��?�?�?? ???� ?�?�??��?��??� �? ??�Ą??���?�??? ?��?���??
?� ?�?���?�?�???�?��???�?� .conf ��?�???� ???� ?�?�??��?��? ?�???��΄?��?��� �? Win ?�?�?����??��??�� ?� ??�??� �?��?�?�?? ???��???�?Ȅ�???

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


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


[originally posted on jforum.net by Serge Maslyukov]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
?? ?�??��?�??�� ?��� ?� ???���?
?� ��??��?�?� �?��?? ??��?���?� �??�?�?�?���� ��???Ȅ�?�?? ?�?�?� ???��܄�??? ??��?�???�???� ???� ???� ����?? ???� ��???���?�?���

?�??��?��?� ?�???����?
[originally posted on jforum.net by AnotherGuest]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
AnotherGuest wrote:?? ?�??��?�??�� ?��� ?� ???���?
?� ��??��?�?� �?��?? ??��?���?� �??�?�?�?���� ��???Ȅ�?�?? ?�?�?� ???��܄�??? ??��?�???�???� ???� ???� ����?? ???� ��???���?�?���

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


�??�?��??�?�?? ?�?�?���?�?�?�???�?�???�?� ??? ?�???�?� - ???���
???�??�? ?�?�?��� �??? ?���???�?��� - http://sourceforge.net/projects/riverock
[originally posted on jforum.net by Serge Maslyukov]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
AnotherGuest wrote:��??,
�� ???�??�? ???��� ��?�???�?� /etc/my.ini
:?:

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

?��??�?� ?�??��?��?���� ???�?? ?�?? ??�Ą??���?Ȅ�, ��?? ��?�?? �??�?�?�?�??? ?�?�?�?�?� ��?�???Ȅ� ?� ?? ?�?�?�??? ?�??�ۄ??�?�?� ??? ?�??�???Ȅ�?��?��� ?? ?�?���?��?��???� ?�???��?�???.
[originally posted on jforum.net by VVD]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Internationalization
 
Similar Threads
User's Created Topics Icon
Missing links to images after installation
Unmaintained translations are removed from 2.1.7
Internationalization
Would you prefer English to your native language?