What are the challenges you face when working across database platforms? Take the survey

MySQL Data Compare wrong charset please help :(

S.LutchkoS.Lutchko Posts: 4
edited June 22, 2013 10:58AM in MySQL Data Compare

I hate to cry 'urgent' especially I know it's Saturday now, but unfortunately it is really urgent.

The error is when I'm at MySQL console I can see utf symbols correctly but your app shows it in a wrong way.

Here is the console:

$ mysql -uroot
Server version: 5.1.69-0ubuntu0.10.04.1 (Ubuntu)

mysql> \u src
Database changed

mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from wp_101_posts where ID=17914 \G
#800000">▲</span>Delta<span style="color: #800000">▲</span>

What I see in the app is question marks instead of any utf symbol. I'd like to attach an screenshot but I don't see such option here.

The main issue it puts these question marks in sync script :(

How can I fix this?

Please help. Thank you.


Sign In or Register to comment.