Armenian Knowledge Base  

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

Reply
 
LinkBack Thread Tools
Old 09.08.2004, 11:28   #1
Младенец
 
Join Date: 11 2002
Location: Skofja Loka , Slovenia
Posts: 19
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default Glyuk s MySQL

Lyudi dobrie , takaya situaciya , stoit mysql servak !
v ney tablica s id i escho odnim stolbom adress

esli adres zakanchivaetsa na russkie bukvi "Л" "К" "И" to pri selec skajhem "select * where adress='ПППЛ' "

on vidayot vse stroki kotorie zakanchivayutsa na "Л" "К" "И" , a s drugimi problem net !!!

Pomogite pojhalusta sovetom , kak bit ?
Reply With Quote
Old 09.08.2004, 12:06   #2
Moderator
 
Join Date: 03 2002
Location: Russia
Posts: 123
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

Надо charset настроить.
http://dev.mysql.com/doc/mysql/en/Charset.html
Reply With Quote
Old 31.08.2004, 11:19   #3
СволочЪ
 
Вирус's Avatar
 
Join Date: 08 2002
Location: Yerevan
Age: 36
Posts: 357
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

Quote:
Originally Posted by x.ice
Lyudi dobrie , takaya situaciya , stoit mysql servak !
v ney tablica s id i escho odnim stolbom adress

esli adres zakanchivaetsa na russkie bukvi "Л" "К" "И" to pri selec skajhem "select * where adress='ПППЛ' "

on vidayot vse stroki kotorie zakanchivayutsa na "Л" "К" "И" , a s drugimi problem net !!!

Pomogite pojhalusta sovetom , kak bit ?
Для сравнения строк более правильно использовать конструкцию LIKE:

... where adress='ПППЛ'

Странно, но на моем MySQL-е твой запрос работает нормально...
Покопайся в настройках...
Reply With Quote
Sponsored Links
Reply

Thread Tools


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

All times are GMT. The time now is 14:31.


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