Devart Forums

Posted: **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АБВ

Posted: **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.

Posted: **Tue 15 Jan 2008 08:46**

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

Devart Forums

Incorrect charset recognition for query field

Incorrect charset recognition for query field