Installation:mysql server is configured to use utf8 by all defaults:
character-set-client-handshake TRUE
character-set-filesystem binary
character-set-server utf8
default-character-set utf8
all
database tables were created or converted to:
CREATE TABLE ... ( ... ) DEFAULT CHARSET=utf8
mysql
jdbcdriver is set up like following:
jdbc:mysql://localhost/queuemetrics?...&useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
file agents.conf are like following:
agent=>001,,"Василий Пупкин
(here is utf-8 string after quote)
Content-Type of all pages is: text/html; charset=UTF-8
User selected Language is "Russian"
Issues:1.
Setup Wizardwhen loading agents from file agents.conf, after specifying filenames,
after page "The specified sources have been succesfully read."
on stage "Source > Agents" it displays unicode strings incorrectly.
(a string of invalid chars 2 times longer then initial)
if to proceed further, on last stage it produces error:
Fail: Problema update DB: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INVALID CHARS' at line 1
the "INVALID CHARS" is string invalid chars (4 times longer then initial string.)
when agent name is put into database tables directly, using mysql-tools, then quemetrics displays it correctly everywhere.2.
Track QAwhen track QA window is opened, and there comment put, it saves in database incorrectly,
and then redisplayed in the wrong way.
when comment is put into database tables directly, using mysql-tools, then quemetrics displays it correctly3.
ExportingExporting just any table into XLS or CSV replaces all unicode characters into "?"
Only XML export works.
