UTF Notice debug

Next topic

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

Author

Message

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 "SET NAMES 'utf8'" ?

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 SET NAMES 'utf8' 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 SQLOutput in site.ini.

--
Amos

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