Inserting Russian characters into MYSQL Database using DataDeploy

Hi,

I am deploying a DCR which is having Russian characters into MYSQL Database using DataDeploy. All the data in DB is appearing as "??????".
I am using UTF-8 encoding in all the configuration files.

Thanks,
Shefali

Find more posts tagged with

Comments

ISCBorisB

Hi,

I am deploying a DCR which is having Russian characters into MYSQL Database using DataDeploy. All the data in DB is appearing as "??????".
I am using UTF-8 encoding in all the configuration files.

Thanks,
Shefali

What is your Platform/OS?
What is your OD Version?
What is your MySQL Version?
What is the value of your <database> Element's "jdbc-driver" Attribute?

What does "data [...] is appearing as ??????" even mean? In other words, what SQL Client have you used to retrieve this Data?

Rick Poulin

What is your Platform/OS?
What is your OD Version?
What is your MySQL Version?
What is the value of your <database> Element's "jdbc-driver" Attribute?

What does "data [...] is appearing as ??????" even mean? In other words, what SQL Client have you used to retrieve this Data?

Also, verify that the database and your SQL Client are both using a UTF-8-compatible charset. I think the default for MySQL is latin1 if you didn't explicitly specify utf8 when creating the schema.

Migrateduser

Platform/OS:-Unix
OD Version:-7.2.1
MySQL Version:-5.0.37
Value of database:

db="dbserver/dbname"
password=""
user=""
vendor="rdbms"
delete-tracker="yes"
enforce-ri="yes"
real-update="no"
cache-db-connection="no"
/>

ISCBorisB

Platform/OS:-Unix
OD Version:-7.2.1
MySQL Version:-5.0.37
Value of database:
<database name="dbInstanceName" jdbc-driver="com.mysql.jdbc.Driver" protocol-url="jdbc:mysql"
db="dbserver/dbname"
password=""
user=""
vendor="rdbms"
delete-tracker="yes"
enforce-ri="yes"
real-update="no"
cache-db-connection="no"
/>

DD Setting looks fine, providing that you are using correct JDBC Driver Version.
From MySQL side, have you configured DB to use UTF-8? Take a look here, it may help.