Comments
4 comments
-
Hi,
Have you tried setting the script encoding? You can change the charset of the script using Tools -> Application Options -> Encoding.
Thanks,
Neil -
Yes, I did but no luck. As far as I understand this setting is for output script only, not for DB connection.
-
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 -
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.
Add comment
Please sign in to leave a comment.
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.