Incorrect charset recognition for query field

[spatar]

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]

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]

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