DataDeploy and Special Characters

GriffTheDog

TeamSite 6.7.1 SP1
OpenDeploy 6.2.0

We create EAs in the TeamSite's New Tagging GUI. We then run a file list deployment with DBloader to move the DCRs to a web server and the EAs to a SQL Server 2005 database.

Problem: DataDeploy turns special characters to garbage before inserting into the database. Example:

é => é
è => èr
ê => ê

The issue, as we see it, is that DataDeploy writes the tuples with the garbage in them (this can be seen in the .eamf) and then DataDeploy inserts the tuples into the database as they are, garbage and all.

We need these character stored in the database properly to allow for searching.

Has anyone else had this issue? Does anyone know a solution?

Thanks in advance for any help with this!

nakumar

While deploying special characters make sure encoding is correct. i.e. while deploying french/german characters in the deployment config. file, put the encoding as "ISO-8859-1" instead of "UTF-8".

[html]

[/html]

Also at the datbase end (in case of SQL 2005) make sure the collation char.set is set correct so that it can store special characters in the database.