[TYPO3] problem with special characters

[Dmitry Dulepov [typo3]]

J.Bakshi wrote:
> I have problem with special characters after migrating a typo3 powered
> site from a remote server to the local server.
> The remote site is working well, but after migrating in the local
> server, some characters have been append by "?" symbol.
> 
>  I have modified the t3lib/class.t3lib_db.php and add a line
> 
> $this->admin_query('SET CHARACTER SET utf8'); after the line $this->link
> = @mysql_pconnect($TYPO3_db_host, $TYPO3_db_username, $TYPO3_db_password);

You know, you trying to open a bottle with a hummer. :( TYPO3 Install tool has a stting where you can enter database initialiation commands like SET NAMES.

> so now it looks like
> 
> ~~~~~~~~~~~~~~~~~~~~
> $this->link = @mysql_pconnect($TYPO3_db_host, $TYPO3_db_username,
> $TYPO3_db_password);
> $this->admin_query('SET CHARACTER SET utf8');
> ~~~~~~~~~~~~~~~~~~~~~~~~
> 
> Now the "?" symbols have been changed to special characters BUT some
> special characters of the same site which are appearing before in this
> local server have been changed to  "?"  symbol.
> 
> What to do so that I get back those special characters too which was
> showing before adding the
> $this->admin_query('SET CHARACTER SET utf8');

Nothing. It is either old or new. You cannot have both.

-- 
Dmitry Dulepov
TYPO3 core team
Web: http://typo3bloke.net/
Skype: callto:liels_bugs
"Nothing is impossible. There are only limits to our knowledge"