[TYPO3-english] TYPO3 and character encoding problems
Pero Peric
pperic at mail.com
Mon Jul 7 10:50:08 CEST 2014
Hi,
I tried to upgrade my TYPO3 4.4.0 ver. to 4.7.19 but I ran into
character encoding problems (in 4.4.0 all is working fine). I would
really appreciate if someone could explain me what is going on here.
In 4.4.0 i have:
[BE][forceCharset] = utf-8
[SYS][setDBinit] is empty, i don't have SET NAMES UTF-8 here.
DB and all tables are created as UTF-8.
My MySQL character encoding variables look like this:
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin2 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin2 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
In 4.4.0 i get all characters displayed correctly.
So this is what i have in MySQL DB (i will show example on 1 character).
Character Č is represented as hex. C384 what is UTF-8 character Ä. Now
what i would really want to know - how the hell something that is UTF-8
character Ä becomes character Č in 4.4.0? I suppose this has something
to do with forceCharset directive so does anybody know what in fact this
directive do?
When i do upgrade to 4.7.19 this character is displayed as Ä (i would
say properly by it's hex. code) but not properly for me :-) If i create
page in 4.7.19 called Č it is stored as right hex. UTF-8 code for char Č
and that is C48C.
So to summerize. In 4.4.0 character Č is stored in DB like hex. C384 and
displayed correctly on the screen, while in 4.7.19 it is displayed as
character Ä.
If someone could explain me what is 4.4.0 doing here maybe i could
convert this properly for 4.7.19. Thank you!
regards.
More information about the TYPO3-english
mailing list