Codepage Issue

Murat H Korkmazov, modified 11 Years ago.

Codepage Issue

Youngling Posts: 9 Join Date: 8/26/10 Recent Posts
Hi there,

Our team use Redmine as the bug-tracking system and your solution is a must have addon to Redmine.

The major problem although for me (and I guess for someone also) is a luck national code pages support.
For example if I tried to create and describe a test-case in Russian it saves ??????? instead of the national symbols.

Could you please tell me if you plan to add support for non-English Code Pages?

Keep up the good work!

BR,
Murat
thumbnail
Torsten Stolpmann, modified 11 Years ago.

RE: Codepage Issue

Jedi Council Member Posts: 770 Join Date: 2/12/09 Recent Posts
Hi Murat,

welcome and thanks for your kind words.

Klaros should already be able to cope with non-English Code Pages.

I suspect that the data base you are using is not able to handle your national symbols.
What kind of database are you using? Is it configured for handling UTF8-Unicode (or your national codepage)?

Regards

Torsten
Murat H Korkmazov, modified 11 Years ago.

RE: Codepage Issue

Youngling Posts: 9 Join Date: 8/26/10 Recent Posts
Torsten, thanks for the prompt reply.

I am playing with demo link that I found on your site:
http://www.klaros-testmanagement.com/demo/pages/homeExecute.seam?conversationId=13

BR
Murat
thumbnail
Torsten Stolpmann, modified 11 Years ago.

RE: Codepage Issue

Jedi Council Member Posts: 770 Join Date: 2/12/09 Recent Posts
Now this is embarrassing ... emoticon

We will change the collation today (it's swedish latin 1 at the moment)

Thanks for pointing this out!

Torsten
Murat H Korkmazov, modified 11 Years ago.

RE: Codepage Issue

Youngling Posts: 9 Join Date: 8/26/10 Recent Posts
Great! Thanks.
thumbnail
Heiner Westphal, modified 11 Years ago.

RE: Codepage Issue

Youngling Posts: 13 Join Date: 3/2/09 Recent Posts
Hello Murat,

our database uses utf8 encoding now (and collation sequence utf8_general_ci),
as it should have been all the time.

Tests with Indonesian and Cyrillic chars worked ok.

Thank you for pointing this out,

Heiner

P.S.: MySQL >= 5.0 makes it quite easy to transform character data:

ALTER TABLE mytable  CONVERT TO CHARACTER SET utf8;

does it.

For all tables in a DB I did (in a bash on linux):
mysql -B -s -e "show tables" myDB | \
awk '{printf "ALTER TABLE %s CONVERT TO CHARACTER SET utf8;\n",$1}' | \
mysql -B  -s myDB


we use
character-set-server=utf8
collation-server=utf8_general_ci
in /etc/my.cnf, in section mysqld
Murat H Korkmazov, modified 11 Years ago.

RE: Codepage Issue

Youngling Posts: 9 Join Date: 8/26/10 Recent Posts
Hi Heiner and Torsten,

Thanks for your prompt response!
I really appreciate it.

--
BR
Murat