ICQ transport codepage problem

pt., 03/06/2009 - 06:15 — foxxxx

Hello.
I have follow problem:
When I write from Jabber to ICQ contacts russian text is broken. Otherwise (from ICQ to Jabber) text is not broke.

I google this problem and was find that solution:
1. Mysql base must be in utf-8
2. In my.cnf must be consist:
[mysqld]
default-character-set = utf8
character-sets-dir = /usr/share/mysql/charsets

[client]
default-character-set = utf8
character-sets-dir = /usr/share/mysql/charsets

citated from: this

Sorry for my english.

Zaloguj się lub zarejestruj by odpowiadać

śr., 03/18/2009 - 05:16 — foxxxx

Tested again

Hello!
The typed text is still broken (Jabber2ICQ).
--
best regards,
foxxxx

Zaloguj się lub zarejestruj by odpowiadać

śr., 03/18/2009 - 10:11 — goldmann

I'm sorry but I see I can't help you (us too). There must be a problem with translating between different character sets. I've tried all combinations in transport settings in Openfire but without success, as you see. I know, this is annoying but at this time I simply can't fix this, sorry.

--
best regards,
Goldmann Marek

Zaloguj się lub zarejestruj by odpowiadać

śr., 03/18/2009 - 11:25 — foxxxx

Respect for you!

Hi!
Sorry, did You read links I posted above? It seems, it is there is an solution;)
(http://www.igniterealtime.org/community/thread/31074)
--
best regards,
foxxxx

Zaloguj się lub zarejestruj by odpowiadać

śr., 03/11/2009 - 05:55 — foxxxx

I googled again:)

Hello!
I was found follow:
1. Adding ?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8 to the URL of the JDBC driver. You can edit the conf/openfire.xml file to add this value.

Note: If the mechanism you use to configure a JDBC URL is XML-based, you will need to use the XML character literal & to separate configuration parameters, as the ampersand is a reserved character for XML.

from: http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database.html

2. Elsewere see thread from official forum: http://www.igniterealtime.org/community/thread/31074.

--
best regards,
foxxxx