Redmine

Dear All,

I have a problem reading text entered into redmine and then imported into reporting tool
via ODBC - get "hash"/"strange characters" (see attachment, the "strange characters" are marked with red)
instead. Our native language is Polish, but we see characters belonging to another codepage.

1. We are using redmine.org and everything is fine with it. Inorder to extend its use we want to import data from redmine to a BI/reporting tool called QlikView via ODBC.
When I did "Show source" in my web-browser when in redmine I see codepage set to utf-8:
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
I set the ODBC-drive codepage to utf-8.

2. Here is the database configuration (it is default, no changes were made):
SHOW VARIABLES LIKE 'collation%';
'collation_connection', 'utf8_general_ci'
'collation_database', 'latin1_swedish_ci'
'collation_server', 'latin1_swedish_ci'

SHOW VARIABLES LIKE 'character_set%';
'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'latin1'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'latin1'
'character_set_system', 'utf8'
'character_sets_dir', '/opt/redmine-1.1.0-0/mysql/share/charsets/'

SHOW CREATE DATABASE bitnami_redmine;
'bitnami_redmine', 'CREATE DATABASE `bitnami_redmine` /*!40100 DEFAULT CHARACTER SET latin1 */'

3. What needs to be done to have the text displayed properly ?

Thank you in advance!
Greg Nowak
info@melle.com