data of enumerations table

Hello all,
I installed redmine using mysql as database. The character set was set to latin1. I manually changed the character sets of all the tables to utf8. Now the problem is that the name column of enumerations table doesnot show of properly in user interface. Can someone please tell me the values in the name column of the enumerations table. There are 9 rows in this table.

Thank you.

Replies (3)

RE: data of enumerations table - Added by Etienne Massip over 13 years ago

Did you try to had the encoding: utf8 parameter to your db connection configuration in config/database.yml ?

BTW, the names are localized, so you should check your locales file (e.g. source:trunk/config/locales/es.yml) to get the translations for the following keys (see source:trunk/lib/redmine/default_data/loader.rb#L163) :

default_doc_category_user
default_doc_category_tech
default_priority_low
default_priority_normal
default_priority_high
default_priority_urgent
default_priority_immediate
default_activity_design
default_activity_development

RE: data of enumerations table - Added by Felix Schäfer over 13 years ago

You can edit the names of the enumerations from redmine, see RedmineEnumerations, just fix the names there.

RE: data of enumerations table - Added by kasto manche over 13 years ago

@ Etienne, Yes i had set up utf8 as encoding in config/database.yml.

Thank you Felix for the image. I updated manually the tables from the figure.

Thank you

(1-3/3)

Project

General

Profile

Redmine