[TYPO3] CoolUri & SQL engine parse ERROR

Andreas Becker ab.becker at web.de
Sat Jul 21 17:13:23 CEST 2007


Hi Folks:

Thats what we do if we set up a utf8 NEW Page


   1. In Appache should be enabled - apache2/conf/httpd.conf
   1. AddCharset UTF-8       .utf8
   1. AddCharset utf-8       .utf8
      (Note that capitalization actually matters (it should not, but
      it does for some browsers).

      2. In Apache should be enabled - apache2/conf/charset.conf
      1. UTF-8       utf8        UTF-8

      3. In MySQL you need settings like this: - mysql/my.ini
      1. [client]
      # The default character set that will be used when a new schema
      or table is
      # created and no character set is defined
      default-character-set=utf8

      # SERVER SECTION
      #
      ----------------------------------------------------------------------
      # The following options will be read by the MySQL Server. Make
      sure that
      # you have installed the server correctly (see above) so it
      reads this
      # file.
      #
      [mysqld]
      # The default character set that will be used when a new schema
      or table is
      # created and no character set is defined
      default-character-set=utf8

      # The default storage engine that will be used when create new
      tables when - solves some non utf8 related problems!!!
      default-storage-engine=INNODB

      4. In PHP5 you'll need to check - php5/php.in
      1. ; As of 4.0b4, PHP always outputs a character encoding by
      default in
      ; the Content-type: header.  To disable sending of the charset,
      simply
      ; set it to be empty.
      ;
      ; PHP's built-in default is text/html
      default_mimetype = "text/html"
      ;default_charset = "iso-8859-1"

      5.  In localconf you'll need the folloeing settings -
   typo3/typo3conf/localconf.php
      1. // T3Pack multi-byte content; change to false for US English
      only sites
      if ($utf8 == 'true')
      {
          $TYPO3_CONF_VARS['GFX']['TTFLocaleConv'] = 'utf-8';
          $TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8';
          $TYPO3_CONF_VARS['SYS']['UTF8filesystem'] = 'true';
          $TYPO3_CONF_VARS['SYS']['multiplyDBfieldSize'] = '1';
          $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES
      utf8;'.chr(10).'SET CHARACTER SET utf8;'.chr(10).'SET SESSION
      character_set_server=utf8;' ;
      }

      // T3Pack PHP5 Settings
      if ($php5 == 'true')
      {
        $TYPO3_CONF_VARS['SYS']['t3lib_cs_convMethod'] = 'iconv';
        $TYPO3_CONF_VARS['SYS']['t3lib_cs_utils'] = 'iconv';
        $TYPO3_CONF_VARS['EXT']['extConf']['cooluri'] =
      'a:3:{s:6:"LANGID";s:1:"L";s:7:"XMLPATH";s:33:"typo3conf/ext/abcstarter/scripts/";s:11:"MULTIDOMAIN";s:1:"1";}';
      }
      6.
   7.



   1.
   1.


   1.




2007/7/21, Elmar Hinz <elmar07 at googlemail.com>:
>
> Michael Meurer wrote:
>
> > Hi all
> >>
> >> Michael Meurer wrote:
> >>> $TYPO3_CONF_VARS['SYS']['multiplyDBfieldSize'] = '2';
> > *****
> >> @Michael: I highly recommend to make the database use UTF-8 natively
> and
> >> then remove that setting.
> >
> > I've read the wiki http://wiki.typo3.org/index.php/UTF-8_support.
> > It was everything fine except for two points: The point above and
> >
> > SET character_set_connection = utf8.
> >
> > I can't read it in the wiki. Can i delete it too?
> >
> > Thanks for your help.
> > Michael
>
>
> Hi Michael, Karsten,
>
> I think it would be a big advantage to have a usable description of UTF-8
> in
> the wiki, instead of a collection of a thousand threads in the NG. The
> current wiki description is IMHO to long and confusing.
>
> Please save the time of all of use. It would be nice if you could place
> a "UTF-8 Quickstart" at the beginning of the WIKI page. Just one paragraph
> long. It would summarize the standard settings, if you use a contemporary
> setup: TYPO3 > 4.0, PHP5 and MySQl > 5.0.
>
> That would really be great and another big step for the usability of T3.
>
> Regards
>
> Elmar
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>


More information about the TYPO3-english mailing list