Redmine

What is locale in your database? There is no problem for utf-8

mysql-server-5.1
should i add something to the database, maybe some package ?
can it be system language support ?
thanks.

If you run this command

mysql> show variables like "char%";

you must see a utf8 codepage. For another codepage you must change it for utf8

this is what i get:

mysql> show variables like "char%";
----------------------------------------------------+ | Variable_name | Value |
----------------------------------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ |
----------------------------------------------------+
8 rows in set (0.00 sec)

is that ok or should i change something ?
thanks.

sorry, i hope this is better.

----------------------------------------------------+ | Variable_name | Value |
----------------------------------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ |
----------------------------------------------------+

You have a latin codepage. Try like this

nano /etc/mysql/my.cnf

skip-character-set-client-handshake=1
default-character-set=utf8

/etc/init.d/mysql restart

You must see like

ok, now it looks like that:

mysql> show variables like "char%";
----------------------------------------------------+ | Variable_name | Value |
----------------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ |
----------------------------------------------------+
8 rows in set (0.00 sec)

restarted mysql and apache.
is there anything else that can do this problem ?
i still can't create project names in hebrew.
thanks.

Can you recreate new database and try with new one?

i can, if i can keep the data and restore it, is there a way to preserve the data ?
thanks.

shahar fleischman wrote:

i can, if i can keep the data and restore it, is there a way to preserve the data ?
thanks.

yes, but you must convert it to utf-8, may be

ok,

should i do the convert inside mysql or on a sql dump file ?
i never done that before.
thanks.

shahar fleischman wrote:

ok,

should i do the convert inside mysql or on a sql dump file ?
i never done that before.
thanks.

try this script

mysqldump -uuser -ppassword --default-character-set=latin1 -n -K --skip-set-charset --skip-create-options --skip-extended-insert --compatible=mysql40 --max_allowed_packet=64K dbname > latin_dump.sql
iconv -f ISO-8859-1 -t UTF-8 latin_dump.sql > utf8_dump.sql
mysql --max_allowed_packet=1M -uuser -ppassword --default-character-set=utf8 database_utf8 < utf8_dump.sql
rm -f *.sql

Or try sql command

ALTER TABLE 'table_name' CONVERT TO CHARACTER SET 'utf8';

ok, i will try one of these and see if it helps.
thanks for all your help.

hi,

after changing all the tables to utf8 and changing all variables to utf8, everything is working fine now.

thanks :)