[TYPO3] CoolUri & SQL engine parse ERROR

Andreas Becker ab.becker at web.de
Sat Jul 21 17:54:41 CEST 2007

Sorry the last post was sent before getting finished! Here the completed one

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

                # 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.
                # The default character set that will be used when a new
schema or table is
                # created and no character set is defined

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

       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 -
             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'] =


        6.   In constants you will need: TYPOSCRIPT Constants Default
(Main/Root) Template
              1.      # cat=advanced/language/1; type=small; label=Content
                      renderCharset = utf-8
              2.    # cat=advanced/language/2; type=string; label=Document
Charset: Normally same as renderCharset.
                      metaCharset = utf-8
              3.    # cat=advanced/typo/3;
label=Document Type
                      doctype = xhtml_trans
                4.   # Send UTF-8 Notification Email Headers
                      # cat=advanced//70; type=string; label=Notification
Email Charset
                      notification_email_charset = utf-8
                      # cat=advanced//30; type=string; label=Email URL
Mode:This option allows you to handle URL's in plain text emails
                      # so long URLS of more than 76 chars are not broken.
This option can be either empty or "76" or "all".
                      notification_email_urlmode = 76
                      # cat=advanced//31; type=string; label=Email
Encoding:This sets the encoding of plaintext emails.
                      notification_email_encoding = quoted-printable

        7.   In setup you will need:  TYPOSCRIPT Setup Default (Main/Root)
              1.      config {
                       ### Items included in TSref order for convenience.
                      ### For more details, see TSref at:
                        renderCharset = {$config.renderCharset}
                        metaCharset = {$config.metaCharset}
                        doctype = {$config.doctype}
                        xhtmlDoctype = {$config.doctype}

                        # Send UTF-8 Notification Email Headers
                        notification_email_charset =
                        notification_email_encoding =
                        notification_email_urlmode =

Perhaps there is even more or better settings then I would like to hear
about them

The posted settings are those from our experimental T3Pack Version which is
working fully on utf8
and until now didn't had any problems with those settings.

If somebody has improvements or corrections it would be nice to hear about
them too!


More information about the TYPO3-english mailing list