problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC

Added by Greg Nowak about 9 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

Replies (7)

RE: problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC - Added by Felix Schäfer about 9 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 about 9 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 about 9 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 about 9 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 Magnifier (1.36 KB)

charset_variables.txt Magnifier (990 Bytes)

RE: problem with text coding when using external reporting tool (QlikView, MS Excel) - access via ODBC - Added by Felix Schäfer about 9 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 about 9 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 about 9 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.

(1-7/7)