[TYPO3] database charset problems

[Sander van Gelderen]

Hello Panagiotis,

It is best to have utf8 in your database and in the TYPO3 installation

For the DB:

- You can find out what character set the db currently uses with 
phpMyAdmin module; when you enter the module from TYPO3 menu, it will 
first show you  the list of tables. Notice the 5th column 'collation'.
Now click the little house icon top left, it will show you the 'welcome' 
page for the db. Here you can see what character set the db uses by default.


For TYPO3, I use 4 settings:

- in your root typoscript template:
page.config.renderCharset = utf-8

- in the install tool:

- enter the following three lines in [SYS][setDBinit]:
SET CHARACTER SET utf8;
SET NAMES utf8;
SET SESSION character_set_server=utf8;

- [BE][forceCharset] = utf-8

- [SYS][UTF8filesystem] = 1
is usefull as well



This setup works for me and I have never had a 'gremlin' since I use it.

HTH,

Sander



Panagiotis Kondaxis schreef:
> Hello all,
> 
> I 've some charset problems with my database.
> 
> My problem is that when i select data with an application outside from typo3
> i get "chinese"-characters.
> (for example 'select name from fe_users')
> 
> I've added $TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8' in localconf.php.
> 
> 
> I 've tried ISO 8859-7 (Greek) (I 'm from Greece) with no result.
> 
> I 've also tried to create manually the typo3 database in a new-clean
> installation with utf8_general_ci and utf8_greek_ci collation but my problem
> remains.
> 
> Any help will be appreciated.
> Thanks in advance.
> 
> Regards.
> Panagiotis.