Forums / Install & configuration / UTF Notice debug

UTF Notice debug

Author Message

Mauro Innocenti

Wednesday 13 July 2005 5:07:56 am

I'm running ezP 3.6.0 on MySQL 4.1.12.
All my settings (ezP ini files and MySQL db) are for utf-8 charset.

Why ezP output log/debugging (in notice.log and on-screen with debug enabled) report for any access the Notice "<b>SET NAMES 'utf8'</b>" ?

My ini settings for utf are:

site.ini:
[DatabaseSettings]
Charset=utf-8

i18n.ini:
[CharacterSettings]
Charset=utf-8

template.ini:
[CharsetSettings]
DefaultTemplateCharset=utf-8

And the MySQL DB is UTF8.

Thanks in advance,
Mauro

Jan Borsodi

Monday 25 July 2005 2:10:24 am

The <b>SET NAMES 'utf8'</b> is not a special notice but part of the SQL output.
It is SQL required for MySQL which tells it which character encoding to use for the connection.

If you don't want to see these notices you have to turn off <i>SQLOutput</i> in site.ini.

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq