2011/1/20 <swagat.le...@accenture.com>: > Hi, I lack on knowledge about "Informatica" software. But if you are really sure that the problem is not on source data and not on backend configuration, then it is just in the middle. :-)
I will be more specific (at least, as far as I can be). In a MySQL, a charset is negotiated on connection. This character set can be different from the server's default. For example, PHP connector uses latin instead of utf8 by default unless specifically configured. Check your software/ODBC settings (if they are available) http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-configuration-connection-parameters.html Charsets can be a mess if you have several layers and only one of them fails, but if you understand fully all of MySQL parameters is not so difficult. -- Jaime Crespo MySQL & Java Instructor Software Developer Warp Networks <http://warp.es> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org