I’‘ve upgraded from Jabberd2s10 to the latest Wildfire yesterday. I’‘ve used a perl script that converts j2’‘s database into an XML file to use with Import/Export plugin. After import all contacts with russian names got converted to ???’‘s. I’‘ve deleted all contacts, converted the russian text into transliterated text and imported it again. Then I manually renamed all the contacts back into russian. But today i’‘ve opened the client at work, and all names are back to ???’‘s again. Here’'s more info about my server:
OS : Fedora Core 4 (SMP Kernel)
Java : 1.5.0_07 Sun Microsystems Inc. – Java HotSpot™ Server VM (bundled)
i’‘ve also tried to change the charset on the jiveRoster table (set it to UTF-8) but that didn’'t help.
v-card doesn’'t work as well. (contains ???)
UPD:
Names manually renamed to UTF-8 via mysql client seem to get retreived right. But when I rename them via client (psi) it doesn’'t get updated in the database right away.
Yes, i’‘ve also found a KB article that said to append ?characterEncoding=utf8 to the connection string, but that didn’'t help.
Stuff manualy renamed now appears like this “Ð?апа” (supposed to be “???”).
Also, what steps should i perform to persist my roster renames (from the client) in the database? Because it doesn’'t really end up there right after I edit my roster (havent had that problem with jabberd2).
Which database are you using? Make sure that it is configured to use utf-8. Some old mysql databases do not support that so you need to specify the utf-8 encoding in the jdbc url.
I have Wildfire 3.1 on Windows, I need to copy my users to new Wildfire 3.1 on FreeBSD (6.0Mysql 5.0JDK 1.5). For copy I use Import/Export plugin, but when I move my users I have ???, it should be some cirilyc text. What I should to do? Wich command I can use to change encoding/charset in my MySql or how I can move my users without ???