problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC
Added by Greg Nowak over 13 years ago
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
Replies (7)
RE: problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC
-
Added by Felix Schäfer over 13 years ago
What charset is your connection configured to? (have a look at config/database.yml
)
RE: problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC
-
Added by Greg Nowak over 13 years ago
Hello!
Where do I find this file (database.yml)?
I set the ODBC connection to be utf-8 - see enclosed screenshot.
Regards,
Greg
RE: problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC
-
Added by Felix Schäfer over 13 years ago
On the Redmine side of things :-) The config/database.yml
is in your redmine directory.
RE: problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC
-
Added by Greg Nowak over 13 years ago
Hello,
Sorry for the delay, but I had to wait for admin to get the information.
The database.yml file does not seem to contain any charset information (see attachment).
I also attach a databse charset information (2nd attachment).
b/r
Greg
database_yml.txt (1.36 KB) database_yml.txt | |||
charset_variables.txt (990 Bytes) charset_variables.txt |
RE: problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC
-
Added by Felix Schäfer over 13 years ago
Mmh, I usually do everything in UTF-8, I don't know what the default for the mysql adapter is, and I don't know what the bitnami guys do there exactly. To be honest, my knowledge of the encoding stuff is somewhat limited to "do everything in UTF-8, period". Maybe ask on the bitnami forums if they have an idea?
RE: problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC
-
Added by Greg Nowak over 13 years ago
Hi!
How do I get to bitnami forums ? Where are they ?
Regards,
Greg
RE: problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC
-
Added by Felix Schäfer over 13 years ago
Greg Nowak wrote:
How do I get to bitnami forums ? Where are they ?
Google is your friend ;-) http://bitnami.org/
To the background: it seems your redmine install is from bitnami, bitnami provides "one-click" installers and ready-to-use VMs with open-source software.