[TYPO3-dev] Index of table sys_refindex

[Martin Kutschker]

Wolfgang Klinger schrieb:
>  *hiya!*
> 
>  On Sat, 04 Nov 2006, Martin Kutschker wrote the following:
> 
>>Heh? We don't store data in latin1 on UTF8 sites. The point in 
>>multiplyDbSize was that Mysql's column length was measured in bytes, so 
>>only half or third of the amount of ASCII letters could be stored for 
>>say Greek or Chinese.
> 
> 
>  So you say that TYPO3 communicates with a new MySQL (> 4.1, 5) in
>  a correct way directly in UTF-8?

No. I was thinking of something else.

>  Wouldn't it be at least necessary to set
> ----
> mysql_query('SET NAMES utf8',$this->link); 
> mysql_query('SET CHARACTER SET utf8',$this->link);
> ----
>  in t3lib_db to make this work?

I think there are several ways to tell the Mysql server and the Mysql 
client which charset to use (server startup options and my.cnf).

Currently TYPO3 does not check the TYPO3 version and its capabilities. So 
it's up to the site admin to send any necessary connection initialization 
code. You can do this already via the TYPO3 configuration.

You could try and rewrite the connection code in t3lib_db so that it checks 
  the server version, the server settings and any forceCharset setting and 
send any SET commands you think are appropriate.

Mind that you will have to deal with settings like forceCHarset=utf8 and a 
DB with latin1 as default charset. I hope no user evr tries to change the 
charset of tables or indvidual fields, which is possible in Mysql.

Masi