Character issues with MS SQL Server

[se1269]

Configuration:
Windows Server 2003 SP2
SugarCRM CE 5.2.0J
IIS 6.0
PHP-5.2.11
MS SQL Server 2005

I just migrated our contacts from our previous contacts system (MS SQL Server 2008) to SugarCRM - using T-SQL scripts to copy data from one system to another.
After the migration, I noticed that some of the names & addresses did not display properly. Working in Geneva, we use a lot of french characters (é è à ...):

Example - see also attached pdf file:
- Address displayed in SugarCRM:
Rue Fr�d�ric Jean 5
Gen�ve
Switzerland

- Same Address stored in SQL Server (in the SugarCRM database):
Rue Frédéric Jean 5 Genève Switzerland

Could someone help me with this issue? If I correct the characters manually from the SugarCRM interface, then the data appeared in the database as éÃ.äüè.... Which might not could either if I integrate SugarCRM with other applications!

Thanks in advance for you help.

[salesagility]

Make sure that the character set defined for the database and the character set defined for sugar are the same.

You'll find the sugar definition in config.php at this line:

'default_charset' => 'UTF-8',

[se1269]

As far as I am aware SQL Server stores unicode in UCS-2 (predecessor of UTF-16).

I tried to set 'default_charset' => 'UTF-16' in the config.php, but it had no effect.

Any other ideas?

[se1269]

I found the following thread:
http://www.sugarcrm.com/forums/showthread.php?t=19977

The solution provided (modification of the index.php) seems to be meeting my needs...
I will start testing!

[se1269]

The solution is working fine for me