[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