Problem with character à (a with accent)

Problem with character à (a with accent)

Tuesday 20 June 2006 2:58:26 am - 2 replies

Author Message

Kristof Coomans

Tuesday 20 June 2006 5:57:48 am

Welcome to the eZ community!

Have you configured your database to use UTF-8?

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

doura 8

Friday 23 June 2006 9:13:39 am

Hello,

thanks for your answer Kristof but my problem isn't solved.

I've installed PHP 4.4.2 and mysql 4.1 and my database is configured to use UTF-8.
The files site.ini.append.php and i18n.ini.append.php is configured correctly too.

Now, I've a new error message and I see in the file "error.log" :

<i>
eZMySQLDB:
Query error: Data too long for column 'data_text' at row 1. Query: UPDATE ezcontentobject_attribute
SET language_id='4', contentclassattribute_id='120',
attribute_original_id='0', sort_key_int='0', sort_key_string='',
data_type_string='ezxmltext',
data_text='<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<section xmlns:image=\"http://ez.no/namespaces/ezpublish3/image/\"\n xmlns:xhtml=\"http://ez.no/namespaces/ezpublish3/xhtml/\"\n xmlns:custom=\"http://ez.no/namespaces/ezpublish3/custom/\">\n <paragraph>essai à la maison</paragraph>\n</section>', data_int='1045487555', data_float='0.000000'
WHERE id='282' AND contentobject_id='75' AND version='1' AND language_code='fre-FR'
[ Jun 23 2006 17:35:32 ] [127.0.0.1] eZDBInterface::commit TRANSID-c56af9695f7cd4ecbfcb33f98543fa82:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-c56af9695f7cd4ecbfcb33f98543fa82. </i>

Finally, I've all configured to use latin1 and there is no more problem... but it's not o good solution...

You must be logged in to post messages in this topic!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.