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 <[EMAIL PROTECTED]>: > 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 > [email protected] > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english _______________________________________________ TYPO3-english mailing list [email protected] http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
