[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Loading Unicode Data to mySQL
From:       Jaime_Crespo_Rincón <jcrespo () warp ! es>
Date:       2011-01-20 14:30:15
Message-ID: AANLkTi=Zk7xsiK+L8zBvrVz9+55qWb-cOzMzzeL9BkYt () mail ! gmail ! com
[Download RAW message or body]

2011/1/20  <swagat.lenka@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=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]