[TYPO3] Typo3-charset or mysql-UTF-8-problem

Alexander Maringer typo3 at maringer-it.de
Mon May 12 19:29:46 CEST 2008


Hi,

we have discovered a strange behaviour  in typo3 Our environment:
Typo3 4.2
Php 5.2.5
Apache2 2.2.8
Mysql5 5.0.51a
Debian lenny

Typo3 runs with UTF-8:
config.renderCharset = utf-8
$TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8'; The database and all 
tables and fields are set to utf-8.

The following sql-statement is executed in exec_INSERTquery in the file 
t3lib/class.t3lib_db.php at the user creation in sr_feuser_register:
INSERT INTO fe_users
(username,password,...)
VALUES
('test_gazinasıroğlu','9fe22d5a275bf2b894d4a918f34847d7',...)

The Mysql-Log includes the following statement:
INSERT INTO fe_users
(username,password,...)
VALUES
('test_gazinasıroÄlu','9fe22d5a275bf2b894d4a918f34847d7',...)

And the value oft he suername in the database is the following:
'test_gazinasıroğlu'

Any login fails, because the select includes the 'test_gazinasıroÄlu', 
where as the table value is 'test_gazinasıroğlu'.
Please look on the third letter from the last ("Ÿ").
The Charset is tr.

Does anybody know this or an equivalent problem with tr and UTF-8?

I think, the reason is somewhere in Mysql.

A copy is in the german list

Thank you a lot for any hint

Regards


Alexander Maringer


More information about the TYPO3-english mailing list