Incorrect charset recognition for query field

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
spatar
Posts: 8
Joined: Thu 04 Oct 2007 08:16

Incorrect charset recognition for query field

Post by spatar » Tue 25 Dec 2007 15:31

MyDevStido v.2.10.77.1

Create database with DEFAULT CHARACTER SET utf8.
Configure connection in MyDevStudio to use Unicode.

Code: Select all

select concat(123, 'АБВ');
returns

Code: Select all

123АБВ
while

Code: Select all

select cast(concat(123, 'АБВ') as char);
returns correct string

Code: Select all

123АБВ

Alexz
Devart Team
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Post by Alexz » Thu 27 Dec 2007 16:02

In fact, if you set Unicode option for connection all data sent to server is in unicode. The function "concat" returns binary string in your case and we do not convert the result to unicode. So, if you'll set off Unicode option for connection you'll get right result or you can use cast.
In the next build of MyDeveloper Studio we'll convert all binary strings recieved from server if the Unicode option specified.

spatar
Posts: 8
Joined: Thu 04 Oct 2007 08:16

Post by spatar » Tue 15 Jan 2008 08:46

Thank you. It's correct as you said in 2.10.78.1.

Post Reply