MySQL Search problem
1 отговора
128 прегледа
MySQL Search problem
imam edin stranen problem
znachi tarsia v MySQL baza danni:
<INPUT TYPE=TEXT NAME=find> - tova idva tuk:
$freefind="%".$find."%";
$result1=mysql_query("select * from maps where name LIKE '$freefind' || keywords LIKE '$freefind' order by name limit $start,$how_much") or die(mysql_error());
i nai strannoto e che kato napisha "г" (g - na kirilitsa) mi izvezhda i takiva vrazki kato "Бузледжа" ili "Ален Мак" kadeto niama i pomen ot "г" - molia daite niakoia ideia kade mozhe da e problema
mersi za vnimanieto
znachi tarsia v MySQL baza danni:
<INPUT TYPE=TEXT NAME=find> - tova idva tuk:
$freefind="%".$find."%";
$result1=mysql_query("select * from maps where name LIKE '$freefind' || keywords LIKE '$freefind' order by name limit $start,$how_much") or die(mysql_error());
i nai strannoto e che kato napisha "г" (g - na kirilitsa) mi izvezhda i takiva vrazki kato "Бузледжа" ili "Ален Мак" kadeto niama i pomen ot "г" - molia daite niakoia ideia kade mozhe da e problema
mersi za vnimanieto
Re: MySQL Search problem
Виж си в manual-а:
--with-charset=CHARSET
.........
By default, MySQL uses the ISO-8859-1 (Latin1) character set. To change the default set, use the --with-charset option:
shell> ./configure --with-charset=CHARSET
CHARSET may be one of big5, cp1251, cp1257, czech, danish, dec8, dos, euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru, koi8_ukr, latin1, latin2, sjis, swe7, tis620, ujis, usa7, or win1251ukr. See section 10.1.1 The Character Set Used for Data and Sorting
НАЙ-добрия клуб ТУК
--with-charset=CHARSET
.........
By default, MySQL uses the ISO-8859-1 (Latin1) character set. To change the default set, use the --with-charset option:
shell> ./configure --with-charset=CHARSET
CHARSET may be one of big5, cp1251, cp1257, czech, danish, dec8, dos, euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru, koi8_ukr, latin1, latin2, sjis, swe7, tis620, ujis, usa7, or win1251ukr. See section 10.1.1 The Character Set Used for Data and Sorting
НАЙ-добрия клуб ТУК