My MySQL database does not support UTF-8. Do I have a problem?
PDF Print E-mail
Written by Administrator
Thursday, 07 August 2008 09:30
No you don't. Versions of MySQL lower than 4.1 do not have built in UTF-8 support. However, Joomla! 1.5 has made provisions for backward compatibility and is able to use UTF-8 on older databases. Let the installer take care of all the settings and there is no need to make any changes to the database (charset, collation, or any other).
Last Updated on Thursday, 07 August 2008 09:30
 

fashion

Powered by Joomla!     Designed by TemplateMonster.com - Joomla Templates Provider!

Profile Information

Application afterLoad: 0.000 seconds, 0.24 MB
Application afterInitialise: 0.043 seconds, 2.19 MB
Application afterRoute: 0.051 seconds, 2.72 MB
Application afterDispatch: 0.195 seconds, 5.09 MB
Application afterRender: 0.302 seconds, 5.37 MB

Memory Usage

5724400

10 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '6iv3k5gudp4itmbggi9khsl0q3'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1337541912' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '6iv3k5gudp4itmbggi9khsl0q3'
  4. UPDATE `jos_session`
      SET `time`='1337542812',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1337542675;s:18:\"session.timer.last\";i:1337542759;s:17:\"session.timer.now\";i:1337542785;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/var/www/sites/ladyburg.ru/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"3cb4c93cbe3fa587b3ae87196948f038\";}'
      WHERE session_id='6iv3k5gudp4itmbggi9khsl0q3'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 46)
      ORDER BY menuid DESC
      LIMIT 0, 1
  8. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access 
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.section
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 17
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 19:40:12' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 19:40:12' )   )    OR  ( a.state = -1 )  )
  9. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='17'
  10. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 46 OR mm.menuid = 0 )
      ORDER BY position, ordering

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None