Encoding in MySQL group

I

iamsaint2011-12-01 08:37:22

MySQL

iamsaint, 2011-12-01 08:37:22

Encoding in MySQL group_concat

Good afternoon.
There was a problem when using group_concat in MySQL (5.1.49-3-log) Cyrillic is returned as ��
Table encoding is cp1251, encoding of the returned result is cp1251, checked as
select charset(descr) from tarifs
and
select charset(group_concat( descr)) from tariffs

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

I

iStyx, 2011-12-01
@iStyx

SET NAMES cp1251have you tried?

L

lashtal, 2011-12-01
@lashtal

Probably a bug, the version is old. We put 5.5.18 and test there.
And another question, to hell with cp1251 on the site, anything can happen, but why keep the base in it? The results / connection can be left in it, and the tables themselves can be converted into human utf.

E

Eugene, 2011-12-01
@Nc_Soft

iamsaint, you are solving a problem that you yourself came up with.
Store in utf