[TYPO3] database charset problems

[Patrick Schl ä pfer]

Hi there
And what about the MySQL Tables/DB?
The scripts in the 1-2-3 installer, do they take care of utf-8.
My tables in the DB have all as "Kollation" latin_swedish_ci,
although the MySQL has UTF-8 Unicode



Am 15.3.2008 22:25 Uhr schrieb "Sander van Gelderen" unter
<mail at sandervangelderen.nl>:

> 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.
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english