Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Charset problem on localhost, could you help? (solved)
I use latest TXP 4.0.3 in czech language. On website is everything OK, but when I copy database to localhost something is wrong. Because the date (January = Leden, February = Únor…) is than not in czech but in english. All texts are in czech, but only date is in english. I made diagnostic and there is result:
Website:
Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: C:\Program Files\EasyPHP1-8\mysql\share\charsets/
18 Tables: OK
Same DB on localhost:
Charset (default/config): cp1250/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_filesystem: binary
character_set_results: utf8
character_set_server: cp1250
character_set_system: utf8
character_sets_dir: /usr/local/share/mysql/charsets/
18 Tables: OK
So, it looks like charset problem.
What do I have to do to view date in czech language?
This problem is two way. Because when I transfer clean install on localhost to website, date is still in english. Argh…!
Last edited by beztak (2006-07-08 20:06:20)
Job: Plugo – tvorba eshopu
Projects: Czech free fonts
Offline
Re: Charset problem on localhost, could you help? (solved)
No, you are misinterpreting the information. Everything is fine (18 Tables: OK). The details are epxlained in textbook (on unicode-support).
Because the date (January = Leden, February = Únor…) is than not in czech but in english.
This points to a problem with the locales that are available on your server.
Offline
Re: Charset problem on localhost, could you help? (solved)
I solved my problem, it was easy, but still I don’t understand how is possible that one value in DB change always when I transfer DB form localhost to website and form website to localhost. The only one thing I had to do is to change in table txp_prefs:
(1, ‘locale’, ‘Czech_Czech Republic.1250’, 2, ‘publish’, ‘text_input’, 0)
with this:
(1, ‘locale’, ‘cs_CZ.UTF-8’, 2, ‘publish’, ‘text_input’, 0)
Now is everything OK.
Job: Plugo – tvorba eshopu
Projects: Czech free fonts
Offline