Re: [SOGo] UTF characters in addressbook

2013-09-02 Thread Szládovics Péter

2013-09-01 22:08 keltezéssel, Szládovics Péter írta:

Dear Guys,

I dont know it is a unique thing or not, but I have a little encoding 
problem.
In my Thunderbird and the SOGo web UI I see the '?' characters in 
names, where originally placed the 'ű' or 'ő' characters.
In the mysql the encoding is latin1_swedish_ci. If I change it to 
utf8_general_ci, this solve my problem?


I'm planning this:

service sogo stop
mysqldump sogo | sed 's/\(CHARSET=\)latin1\(;\)$/\1utf8\2/' | mysql sogo
service sogo start

Should it help on me?

PS: The terminal is hu_HU.UTF-8


I was not too patient in this situation, and tried it after a full DB 
backup.
I needed an alter database command too to set the default encoding, 
cause SOGo will create other tables at the future.


It's working. :)
--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] UTF characters in addressbook

2013-09-01 Thread Szládovics Péter

Dear Guys,

I dont know it is a unique thing or not, but I have a little encoding 
problem.
In my Thunderbird and the SOGo web UI I see the '?' characters in names, 
where originally placed the 'ű' or 'ő' characters.
In the mysql the encoding is latin1_swedish_ci. If I change it to 
utf8_general_ci, this solve my problem?


I'm planning this:

service sogo stop
mysqldump sogo | sed 's/\(CHARSET=\)latin1\(;\)$/\1utf8\2/' | mysql sogo
service sogo start

Should it help on me?

PS: The terminal is hu_HU.UTF-8
--
users@sogo.nu
https://inverse.ca/sogo/lists