Defect #3392
closed
Issue categories length and utf-8 problem
Added by Dr. Agon Smith over 15 years ago.
Updated almost 10 years ago.
Description
When importing from trac using migrate_from_trac.rake I found issue categories names are сut off and their length is shorter then 30 characters (about 15 characters len). Issue categories were written in Russian in utf-8 encoding.
I looked for at the IssueCategory class definition and made sure it should be 30 char length. I'm using redmine 0.8.4.
Forgot to mention. When I used migrate_from_trac.rake i've entered "UTF-8" (default answer).
Dr. Agon Smith wrote:
Forgot to mention. When I used migrate_from_trac.rake i've entered "UTF-8" (default answer) as database encoding.
Ok, the same problem in version 0.9.3. Details in the duplicated ticket #4990.
I solve the same problem by adding
encoding: utf8
in database.yml
Datebase was created with command
create database redmine character set utf8;
My redmine version is 0.9.3
I solve problem. See #5154.
Well this seems to be related to utf-8 datalenght.
If you define a database field which should hold 30 chars á 1byte, everything works fine. If you import utf-8 data which has 2 byte per char, everything went wrong. (30/2 = 15 chars)
I'm not sure if this is solved due to recent changes in redmine, but it would be nice if someone could check this.
Please take also a look at #5154.
- Status changed from New to Closed
- Resolution set to Wont fix
Character length is different in Ruby 1.8 or not.
1.8.7-head :001 > "日本語".length
=> 9
1.9.3-p551 :001 > "日本語".length
=> 3
- Related to deleted (Defect #5154: Migrate from Trac with postgresql and more.)
- Has duplicate Defect #5154: Migrate from Trac with postgresql and more. added
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 
Updated by Toshi MARUYAMA