- 07 Sep 2012, 10:19
#1573
Hello,
i'm testing opencats for a day now and encountered a severe problem with the charsets. As i come from germany, we have some special characters an mutations (i.e. ä, ü ...). Now there are some crazy "two way" problems. First, when i add a new candidate like Mr. Möller, the name is shown correctly in my web browser (FF 15.0) in dashboard, candidates pages, activities and lists, but the characters in the database look like this: Mr. Möller. There not correctly shown in the calendar in the Event View, too.
If i add a new event, the event title is not correct in database and calender overview.
If i correct the database entries manually, there correct in the database but incorrect at the candidates page in case of the candidates names. The event title is incorrect in the calendar upcoming events page only (example: Bewerbergespr?ch). The shown event in calendar and the view event section is okay.
On the opposite, when i add a extra field for the candidates section, the name is correct in the database, but not in the add extra field section (like: Nationalit?t). Same for the shown field in the candidates section.
I don't know what to do. Database Tables are all on utf-general-ci or utf-unicode-ci, server charset in php myadmin is shown as utf-8-unicode and mysql connection collation on utf-8-general-ci. Browser as well.
How can i get with this? Any ideas?
Second question goes to time and date formats. Has anyone experience in changing date format to dd.mm.yyyy (instead of dd-mm-yy in UK localization) and time format to 24 hour format? I tried to play with the .php data but managed only to get a dd-mm-yyyy display in the view event section. When i try to set '.' instead of '-' then i get a mm.dd.yyyy displayed. Very tricky.
Other date format changes didn't work but i don't know in which files i have to make changes. I've tried a little bit with de DateUtility.php but as i said without success so far.
Any help on both issues is very much appreciated.
Thank you!
I forgot my configuration: Win Xp, Wamp 2.2, MySQL 5.5.24, PHP 5.3.13, Apache 2.2.22, FF 15.0
i'm testing opencats for a day now and encountered a severe problem with the charsets. As i come from germany, we have some special characters an mutations (i.e. ä, ü ...). Now there are some crazy "two way" problems. First, when i add a new candidate like Mr. Möller, the name is shown correctly in my web browser (FF 15.0) in dashboard, candidates pages, activities and lists, but the characters in the database look like this: Mr. Möller. There not correctly shown in the calendar in the Event View, too.
If i add a new event, the event title is not correct in database and calender overview.
If i correct the database entries manually, there correct in the database but incorrect at the candidates page in case of the candidates names. The event title is incorrect in the calendar upcoming events page only (example: Bewerbergespr?ch). The shown event in calendar and the view event section is okay.
On the opposite, when i add a extra field for the candidates section, the name is correct in the database, but not in the add extra field section (like: Nationalit?t). Same for the shown field in the candidates section.
I don't know what to do. Database Tables are all on utf-general-ci or utf-unicode-ci, server charset in php myadmin is shown as utf-8-unicode and mysql connection collation on utf-8-general-ci. Browser as well.
How can i get with this? Any ideas?
Second question goes to time and date formats. Has anyone experience in changing date format to dd.mm.yyyy (instead of dd-mm-yy in UK localization) and time format to 24 hour format? I tried to play with the .php data but managed only to get a dd-mm-yyyy display in the view event section. When i try to set '.' instead of '-' then i get a mm.dd.yyyy displayed. Very tricky.
Other date format changes didn't work but i don't know in which files i have to make changes. I've tried a little bit with de DateUtility.php but as i said without success so far.
Any help on both issues is very much appreciated.
Thank you!
I forgot my configuration: Win Xp, Wamp 2.2, MySQL 5.5.24, PHP 5.3.13, Apache 2.2.22, FF 15.0