Change of server collation to UTF-8

[miamiman]

This is probably really easy/stupid, but we don't know where to turn.

Because of other applications, we changed our server collation settings from latin1_swedish_ci to utf8_unicode_ci, and got GARBAGE in our Sugar Installation.

Like this: "��������]{s��[��w@�i(OO�.����yw�"

We set it back to utf8_unicode_ci and we still have GARBAGE.

Oh please tell me that this is an easy php.ini configuration fix!

Thanks.

[salesagility]

Have you checked the database directly? Do you have access to a tool like phpmyadmin or sqlyog?

The default for sugar charset is held in config .php

'default_charset' => 'UTF-8',

But you need to ensure the integrity of the data first

[miamiman]

Thank you!

It's always great to get a timely response from the forums.

We are checking our server settings and will advise what our final solution was.

We have checked our data, and it is NOT corrupt.

[miamiman]

Well, we're two days into this and still haven't figured out why we are getting character garbage.

1. We downloaded the sugar install and locally everything is fine.
2. We installed a second fresh install to the server and get garbage.

We've been advised that database, php, and apache are all set to UTF-8.

• The server people suggested modifying the httaccess file to include character encoding to:
  AddDefaultCharset UTF-8

Yes / no?

If so, which one the public folder or the sugar install folder, or both.

Any suggestion?