You are not logged in.
I've problem with tMysqlConnection. Data in the databse are stored in latin1 so I need to set up jdbc connector to use this character set. Unfortunately setting up tMysqlConnection Additional JDBC Parameters to "characterSetResults=CP1252" (latin1, iso8859_1) does not affect output.
When I connect on the server and use following connection command everything goes right:
mysql -p pc --default-character-set=latin1 mysql> select last_name from candidate where candidate_id=3; +-------------+ | last_name | +-------------+ | KovŠřovŠ |
Same when I'm connecting with MySQL workbench:
SET character_set_results = latin1; SELECT last_name FROM `pc`.`candidate` where candidate_id=3;
Is there a way to run "SET character_set_results = latin1"; command before any future select? Or is there way to make connection right?
1. Append this parameter useUnicode=true&characterEncoding=xxx into tMysqlConnection Additional JDBC Parameters.
2. Use a tMysqlRow to execute statement ""SET character_set_results = xxx" before any future select, eg:
on tMysqlRow, check the box' use an existing connection'