Another MySQL question

hov · May 17, 2003, 12:33

Tak.....

xosqi

CREATE TABLE `chars` (
`field` char(1) NOT NULL default ''
) TYPE=MyISAM;

Heto lcnum em liqy ruseren tarer.
Heto

SELECT FROM chars WHERE field = 'д';
berum a erku togh 'д'-ov u 'ж'-ov

SELECT FROM chars WHERE field = 'л';
berum a erku togh 'л'-ov u 'и'-ov

SELECT FROM chars WHERE field = 'о';
berum a ereq togh 'о'-ov 'м'-ov u 'п'-ov

ba heto? senc karelia !?

hayk · May 18, 2003, 12:48

Надо поменять charset. По умолчанию там latin1, а должно быть win1251.
Про это написано в мануале - http://www.mysql.com/doc/ru/Character_sets.html

Или же делать так
SELECT * FROM chars WHERE field regexp 'д';

May 17, 2003, 12:33	#1
hov В бой аргхххххххх! Join Date: Sep 2002 Location: Vik, Medieval Norway Posts: 1,497 Rep Power: 7 Reputation: 48	Another MySQL question Tak..... xosqi CREATE TABLE `chars` ( `field` char(1) NOT NULL default '' ) TYPE=MyISAM; Heto lcnum em liqy ruseren tarer. Heto SELECT FROM chars WHERE field = 'д'; berum a erku togh 'д'-ov u 'ж'-ov SELECT FROM chars WHERE field = 'л'; berum a erku togh 'л'-ov u 'и'-ov SELECT FROM chars WHERE field = 'о'; berum a ereq togh 'о'-ov 'м'-ov u 'п'-ov ba heto? senc karelia !?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 18, 2003, 12:48	#2
hayk Moderator Join Date: Mar 2002 Location: Ukraine Posts: 123 Rep Power: 7 Reputation: 10	Надо поменять charset. По умолчанию там latin1, а должно быть win1251. Про это написано в мануале - http://www.mysql.com/doc/ru/Character_sets.html Или же делать так SELECT * FROM chars WHERE field regexp 'д';