ciruliz Posted September 7, 2004 Report Share Posted September 7, 2004 Taatad, nekad ieprieksh shii te probleema nav bijusi aktuaala, taapeec tagad naakas mekleet padomus. KAA MYSQL saprotas ar LV valodu??? Nav iistas skaidriibas par dazhnedazhaadajiem kodeejumiem. Dati ir datubaazee, ne unicode formaataa. Web-lapai noraadiits windows-1257 (taatad LV ) charsets, caur kuru tad arii tika vadiiti dati ieksh DB. Ar atteeloshanu wiss OK. Cik saprotu, tas nav tas pats , kas UTF-8. Kas tas vispaar ir & kaapeec vajadziigs? Citreiz, kad ir naacies glabaat datus gan RU gan LV pie ievades/izvades html codam uzstaadu charset windows-1257 vai 1251 un viss iet kaa naakas. nekaadas citas konfiguraacijas neveicu. BET order by nestraadaa korekti. Dazhus raxtus atpakalj tika teikts, ka tas nav iespeejams bez php papildus sort'eeshanas uz unicode. neticaas, taapeec varbuut kaadam ir kaadi padomi?? PIEMEERAM mekleeshana straadaa korekti, ja raxtaam nevis WHERE lv_lauks = 'āē', bet gan WHERE lv_lauks REGEXP 'āē'; Link to comment Share on other sites More sharing options...
bubu Posted September 8, 2004 Report Share Posted September 8, 2004 MySQL zem 4.1 versijas nemāk sortēt unicodē (UTF-8) Link to comment Share on other sites More sharing options...
ciruliz Posted September 9, 2004 Author Report Share Posted September 9, 2004 unicode == utf8 ?? Link to comment Share on other sites More sharing options...
ciruliz Posted September 9, 2004 Author Report Share Posted September 9, 2004 ok, unicode ir utf8, bet man tas viss nav unicode, ja mees maakam lasiit!! ANSI taatad. un kaa tad sortee LV?? Link to comment Share on other sites More sharing options...
neonz Posted September 11, 2004 Report Share Posted September 11, 2004 Unicode nav UTF-8. UTF-8 ir Unicode. Liidziigi kaa Ford ir automobiilis, bet automobiilis nav Ford. Jo Unicode var tikt enkodeets arii kaa UTF-7 vai UTF-16. Link to comment Share on other sites More sharing options...
ciruliz Posted September 11, 2004 Author Report Share Posted September 11, 2004 UTF-16 & utf-7 ? Kaa tas izpaužas? Unicode, cik man zināms, viens simbols aizņem 2 baitus (16 bitus) & citu iespēju nav. Link to comment Share on other sites More sharing options...
bubu Posted September 11, 2004 Report Share Posted September 11, 2004 Nea, unicode != 2 baiti. bet windows unicode gan = 2 baiti :) UTF-8 - tas ir unicodes kodējums daudzbaitu virknēs (simboli, kuriem ASCII < 128 = UTF-8, pārējie 2-4 baiti) UTF-16 - viens simbols = 2 vai 4 baiti) UTF-32 - viens simbols = 4 baiti sīkāk: http://en.wikipedia.org/wiki/Utf-8 http://en.wikipedia.org/wiki/UTF-16 http://en.wikipedia.org/wiki/UTF-32 Link to comment Share on other sites More sharing options...
Recommended Posts