Armenian Knowledge Base  

Go Back   Armenian Knowledge Base > Technical sections > Webmaster Zone > Web Development
Register

Reply
 
LinkBack Thread Tools
Old 17.05.2003, 13:33   #1
В бой аргхххххххх!
 
hov's Avatar
 
Join Date: 09 2002
Location: Vik, Medieval Norway
Age: 35
Posts: 1,513
Downloads: 12
Uploads: 0
Reputation: 43 | 3
Default 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 !?
Reply With Quote
Old 18.05.2003, 13:48   #2
Moderator
 
Join Date: 03 2002
Location: Russia
Posts: 123
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

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

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

Thread Tools


На правах рекламы:
реклама

All times are GMT. The time now is 06:04.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.