MySQL Data Compare wrong charset please help :(

S.Lutchko

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.

neil.anderson

Hi,

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

Thanks,
Neil

S.Lutchko

Yes, I did but no luck. As far as I understand this setting is for output script only, not for DB connection.

neil.anderson

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

S.Lutchko

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.