[TYPO3] problems with utf8 after migration

Rakowski Tomasz raczek at open.infi.pl
Tue Jan 9 15:00:00 CET 2007


hello!

recently I had to move my Typo3 instalation into a new location. 
Unfortunately there is a problem with polish characters. I am almost 
100% sure it's because of some utf8 related issues. Unfortunately I do 
not know how to cope with that further, I have already lost many hours 
today, yesterday etc

Here is my situation:

My new system is FreeBSD 6.1
PHP 4.4.3
MySQL 5.0.27
Typo3 3.8.0


SQL settings are as follows:

character_set_client  	utf8
character_set_connection 	utf8
character_set_database 	latin2
character_set_filesystem 	binary
character_set_results 	utf8
character_set_server 	utf8
character_set_system 	utf8
collation_connection 	utf8_bin
collation_database 	latin2_general_ci
collation_server 	utf8_polish_ci


Typo3 settings:

config.renderCharset = utf-8
$TYPO3_CONF_VARS['SYS']['t3lib_cs_convMethod'] = 'mbstring';
$TYPO3_CONF_VARS['SYS']['t3lib_cs_utils'] = 'mbstring';
$TYPO3_CONF_VARS['SYS']['multiplyDBfieldSize'] = 1;

I have also modified file t3lib/class.t3lib_db.php:

in function sql_pconnect I added the following lines

         @mysql_query('SET NAMES utf8',$this->link);
         @mysql_query('SET CHARACTER SET utf8',$this->link);

just before return.



My old system is FreeBSD 6.2
PHP 4.4.2
MySQL 4.1.18
Typo3 3.8.0

SQL settings:
character_set_client  	utf8
character_set_connection 	utf8
character_set_database 	latin2
character_set_results 	utf8
character_set_server 	latin2
character_set_system 	utf8
collation_connection 	utf8_polish_ci
collation_database 	latin2_general_ci
collation_server 	latin2_general_ci



When I export database as gzip and import this into new database I see 
in the backend that all polish letters were replaced by ??.
If I want to edit those entries and I put any polish character instead 
of those ?? I get Typo3 error:

102: These fields are not properly updated in database: (title) Probably 
value mismatch with fieldtype.

Furthermore, if I go to frontend I receive message: No template found - 
and believe me there is a template... (maybe my template contains some 
polish characters and that's the reason - I dont know, still have to 
check it.)


thx for your attention and hope someone will help me

racco


More information about the TYPO3-english mailing list