[TYPO3] Need help to set up website languages

Dmitry Dulepov [typo3] dmitry at typo3.org
Mon Jan 21 19:02:46 CET 2008


Hi!

BMolayi at datacolor.com wrote:
> Thanks Dmitry. I got that part right.
> To set the database character set (for MySQL 5), I am planning to run
> the following SQL queries:
> 
> "ALTER DATABASE XXXXX CHARACTER SET utf8 COLLATE utf8_general_ci;"  (to
> set the database), and:
> "ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8;"  for all Typo3
> tables, to set the character set and field lengths for all the tables.
> 
> Is this the right thing to do? Or there is a better way?

This will render some serialized strings unusable. For example, TemplaVoila will loose all mappings.

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


More information about the TYPO3-english mailing list