Grey_Wolf Posted March 15, 2006 Report Share Posted March 15, 2006 (edited) kas vareetu buut par probleemu? Db tabula dati: z,ā,p,a,ž,i,ī,i,š,ss,sš,ķ,Ķ pieprasijums: SELECT `lauks` FROM `kautkasss` ORDER BY lauks atgriež: ā,a,i,ī,i,ķ,Ķ,p,ss,sš,š,z,ž ----------- tas ir sakaarto tikai daļēji... izmēģinājos visādi :( gan barot iekšā: SELECT `sdsfdsd` FROM `kautkasss` ORDER BY `sdsfdsd` COLLATE utf8_latvian_ci ------ Tabulas lauks ir utf8_latvian_ci: SQL 4.1.16 kodejums UTF-8... itkaa viss ir... tik kaarto kautkaa diivaini :( Edit: nu jaa vel SQL Db un tabulas iestaadijumi ir: --------------- character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_results utf8 character_set_server utf8 character_set_system utf8 collation_connection utf8_latvian_ci collation_database utf8_latvian_ci --------------------- Edited March 15, 2006 by Grey_Wolf Link to comment Share on other sites More sharing options...
Kristabs Posted March 15, 2006 Report Share Posted March 15, 2006 taisi atsevishkju kolonu, kuraa duplicee taas kolonas datus, peec kuras gribi ordereet, repleisojot "š"->s, etc un orderee peec taas. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted March 15, 2006 Author Report Share Posted March 15, 2006 Kristabs --> marazmaatiski :( Vai tieshaam vairaak nevienam nav bijushi shaada probleema? P.S. uz hostetaaju servera shii pati probza... buus vel jaapameegjina citur... Link to comment Share on other sites More sharing options...
GedroX Posted March 15, 2006 Report Share Posted March 15, 2006 (edited) Uztaisi tabulu `burti`, kurā ir div kolonnas burta id (int2) un pats burts. Join-o pēc pirmā burta pie šīs tabulas, order by burts.id un gatavs. Vēl nedaudz jāpiefiško, ko darīt ar citiem simboliem (kādi IF, kuri salīdzina ar burtiem 'A' un 'z', ja nu JOIN atgrieza burti.id kā NULL). Tikai tas kārto pēc pirmā burta :(... Raksti MySQL funkciju! Viss! =) Edited March 15, 2006 by GedroX Link to comment Share on other sites More sharing options...
Grey_Wolf Posted March 15, 2006 Author Report Share Posted March 15, 2006 GedroX--> kaa jau mineeju tas ir marazmaatiski :( tas var buut tikai probleemas pagaidu risinaajums, nevis atrisinaajums.... peec idejas Mysql 4.1 vajadzeetu pasham kaartot peec alfabeeta.... pilns Inets ar paraugiem kaa kaartot peec UTF8_persian_ci ... :( '@#$&$' saak likties ka taa ir SQL kljuuda :( (darbaa ar UTF8 ) peec idejas visam vajadzeetu kaartoties ja tiek noraadiits COLLATE un vajadziigais kodeejums... ( UTF8_latvian_ci ) tik kautkas neiet kaa naaks :( manuaalii ir smuki noraadiits ka tam vajadzeetu straadaat, tik nestraadaa (nezkaapeec korekti neizpildaas tas COLLTE) Link to comment Share on other sites More sharing options...
Recommended Posts