VieS Posted April 4, 2005 Report Share Posted April 4, 2005 Ir utf8 bāze: 1 Jānis 2 Pēteris 3 Anna 4 "Žora" 5 Žubīte 6 'Ašais' kā ar MySQL sakārtot, lai sanāktu Anna 'Ašais' Jānis Pēteris "Žora" Žubīte nevis Anna Jānis Pēteris Žubīte 'Ašais' "Žora" Link to comment Share on other sites More sharing options...
bubu Posted April 4, 2005 Report Share Posted April 4, 2005 A dokumentācija nav jālasa? <_< http://dev.mysql.com/doc/mysql/en/string-functions.html SELECT vards FROM tabula ORDER BY REPLACE(vards, "'", "") (protams to pašu ar " simbolu) Link to comment Share on other sites More sharing options...
Venom Posted April 4, 2005 Report Share Posted April 4, 2005 un labāk tomēr atsevišķā kolonnā likt bez ' un " pie ūsera pievienošanas Link to comment Share on other sites More sharing options...
bubu Posted April 4, 2005 Report Share Posted April 4, 2005 Noteikti, citādi jau indeksi manuprāt neizmantosies. Link to comment Share on other sites More sharing options...
Recommended Posts