MySQL Data Compare wrong charset please help :(

Compares and synchronizes MySQL database content

Moderators: Chris Auckland, eddie davis, Michael Christofides

MySQL Data Compare wrong charset please help :(

Postby S.Lutchko » Sat Jun 22, 2013 9:41 am

Hello,

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.
S.Lutchko
 
Posts: 3
Joined: Sat Jun 22, 2013 9:37 am

Postby neil.anderson » Sat Jun 22, 2013 1:55 pm

Hi,

Have you tried setting the script encoding? You can change the charset of the script using Tools -> Application Options -> Encoding.

Thanks,
Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby S.Lutchko » Sat Jun 22, 2013 2:01 pm

Yes, I did but no luck. As far as I understand this setting is for output script only, not for DB connection.
S.Lutchko
 
Posts: 3
Joined: Sat Jun 22, 2013 9:37 am

Postby neil.anderson » Sat Jun 22, 2013 2:52 pm

Ok I've tried to ensure that the connection is set to unicode. Previously it was "auto".

http://download.red-gate.com/EAP/MySQLD ... .0.492.exe
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby S.Lutchko » Sat Jun 22, 2013 3:58 pm

Hmmm, now it shows

800000">^</span>Delta<span style="color: #800000">^</span

the caret sign, shift+6

Is it supposed to be so?

I decided to test before post this reply and found that log text fields (text or longtext) in the sync script were truncated to 1024 bytes.

Thanks God, I don't put it to live site and check manually first.

Anyway please take your weekend, I already found a workaround so there is no need to hurry.

Thank you for willing to help.
S.Lutchko
 
Posts: 3
Joined: Sat Jun 22, 2013 9:37 am


Return to MySQL Data Compare

Who is online

Users browsing this forum: No registered users and 0 guests

cron