elvman Posted August 28, 2007 Report Share Posted August 28, 2007 (edited) Kaut kad biju uzdūries rakstam par to, kā var select'ēt no MySQL neievērojot garumzīmes/mīkstinājumzīmes utt. t.i. visi charakteri tiek konvertēti uz attiecīgo ASCII characteru, piemēram, ā->a, č->c, ō->o. Bet nevaru vairs neko tādu atrast. Tātad man ir vajadzīgs, lai šis kvērijs: "SELECT name FROM table WHERE name LIKE 'āšņīšņōšņā%'" mysql uztvertu kā "SELECT name FROM table WHERE name LIKE 'asnisnosna%'". Edited August 29, 2007 by elvman Link to comment Share on other sites More sharing options...
Paulinjsh Posted August 28, 2007 Report Share Posted August 28, 2007 tur jāuzliek pareizs collocation (nez kā lv iztulkot), piem., utf8_general_ci Link to comment Share on other sites More sharing options...
Grey_Wolf Posted August 29, 2007 Report Share Posted August 29, 2007 Paulinjsh --> vinjam vajag lai NeNem veraa ;) elvman --> skjiet ka tu domaaji par kaadu no iebuvetajaam MYSQL funkcijam kas apstraadaa stringus... paskaties seit P.S. izlabo topika nosaukumaa kljuudu ... savaadak var parprast.... Link to comment Share on other sites More sharing options...
NiTrino Posted August 29, 2007 Report Share Posted August 29, 2007 datu bāzei charset kā utf8 un lapā mysql_query("SET NAMES utf8"); man strādā - ja laukā ir ierakstīts 'ābols', atrod gan pēc 'abols', 'Ābols', 'ĀbOlS'. Link to comment Share on other sites More sharing options...
Paulinjsh Posted August 29, 2007 Report Share Posted August 29, 2007 grey_wolf tikai pasaki, ka ņems vērā :P Link to comment Share on other sites More sharing options...
Grey_Wolf Posted August 29, 2007 Report Share Posted August 29, 2007 Paulinjsh --> ko njems veeraa? Topika nosaukumu izlabos? --> jau ir izlabots... Link to comment Share on other sites More sharing options...
elvman Posted August 29, 2007 Author Report Share Posted August 29, 2007 Es imantoju WIndows1257, nevis UTF8. Un man meklēšanā ž un z tiek uztverti, kā atšķirīgi burti. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted August 29, 2007 Report Share Posted August 29, 2007 elvman --> tu apskatijies to linku ko tev iedevu? tas nav tas pats kas SET NAMES ... Link to comment Share on other sites More sharing options...
Delfins Posted August 29, 2007 Report Share Posted August 29, 2007 collocation (nez kā lv iztulkot) `kopvietošana` Minētajā linkā viss ir, nesaprotu ko jūs te cepaties!? Link to comment Share on other sites More sharing options...
elvman Posted August 29, 2007 Author Report Share Posted August 29, 2007 Minētajā linkā viss ir, nesaprotu ko jūs te cepaties!? Tu domā šo: "[_charset_name]'string' [COLLATE collation_name]"? Ja jā, tad īsti nesapratu, kā tas atrisinātu manu problēmu. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted August 29, 2007 Report Share Posted August 29, 2007 elvman --> a tu palasi paskaidrojumus... Link to comment Share on other sites More sharing options...
Delfins Posted August 29, 2007 Report Share Posted August 29, 2007 Elvman, tu takš krutais gamer koders.. dokumentācijas značit lasīt māki... Paskaties pa labi - "Section Navigation" .. tur viss ir.... izlasi un updeito savu DB, lai vēlāk visi jautājumi atkristu. Link to comment Share on other sites More sharing options...
bubu Posted August 29, 2007 Report Share Posted August 29, 2007 Elvman, tu takš krutais gamer koders.. dokumentācijas značit lasīt māki... 99% gadījumu šis secinājums nav patiess. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted August 29, 2007 Report Share Posted August 29, 2007 Elvman, tu takš krutais gamer koders.. dokumentācijas značit lasīt māki... bubu --> a starp rindinjam lasiit? ;) ;) ;) Link to comment Share on other sites More sharing options...
Recommended Posts