[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