UTF-8 charset question

[coolest]

Hi,

charset is making me crazy

My current configuration is

debian
my-sql 4.1.11
apache 1.3.33
php 4.3.10-16
sugar 4.2.1d

I have set the DB with utf-8 charset. If I do an insert with words like "funzionerà" in the DB I will find "funzionerà". Good!

I have set php with utf-8 as default charset in the php.ini file (/etc/php4/apache/php.ini).
This is my phpinfo extract:

HTTP Headers Information
HTTP Request Headers
HTTP Request GET /info.php HTTP/1.1
Accept text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Encoding gzip,deflate
Accept-Language it,it-it;q=0.8,en-us;q=0.5,en;q=0.3
Connection keep-alive
Host luparense.dyndns.org
Keep-Alive 300
User-Agent Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; it; rv:1.8.1.5) Gecko/20070713 Firefox/2.0.0.5
HTTP Response Headers
X-Powered-By PHP/4.3.10-16
Keep-Alive timeout=15, max=100
Connection Keep-Alive
Transfer-Encoding chunked
Content-Type text/html; charset=iso-8859-1

This last line could be a problem? ISO or UTF? How can I change it?

I have set sugar with utf-8 default charset in the config.php file:

'default_charset' => 'UTF-8',
'default_email_charset' => 'UTF-8',

If I add an account with name "funzionerà" in the db I get "funzioner". Not good

In the html source I have noticed this line in the HEAD:
<meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"/>

Maybe this should be utf-8?

Thanks. Bye.

-- Nicola

[Markku]

sugar 4.2.1d is not using UTF-8. UTF-8 support was introduced in Sugar 4.5, maybe you can upgrade your installation?

[coolest]

I am afraid of upgrading. Is it a secure operation? I mean i would not lost some data or configuration. I notice that some user had problems upgrading to 4.5

Anyone has been able to switch to utf-8 without upgrading?

Is there a safe upgrade sequence in order to grant no data or configuration loss?

Thakn you.
-- Nicola

[Markku]

I'd suggest to create a copy of your existing installation and upgrade it, then you'll see how it goes.

[coolest]

Successfully upgraded. Now the UTF-8 charset does its job

Thank you.

-- Nicola