MySQL Forums
Forum List  »  Serbian/Croatian/Bosnian

koji character set
Posted by: Josip Cagalj
Date: March 04, 2009 03:31AM

Evo i ja imam pitanje.
Nedavno san prešao na korištenje 'nove'(hm, novije za mene) MySql baze 4.1.7 i imam problema sa odabirom character set-a i collatio-nom.
Naime, treba mi insert svih naših specifičnih slova (č,ć,đ,š,ž) ali i sortiranje po istim.
Postoje dva seta preporučena za hrv postavke to su: char set latin2 s latin2_croatian_ci collateom i drugi character set cp1250 i odgovarajući collate cp1250_croatian_ci. Problem je što s ova dva seta ne mogu uspješno insertitat vrijednosti koji sadrže neka od načih slova (pretvara ih u '?')
Eksperimentirao sam s utf8 i slično ali tu sortiranje nije baš najispravnije pa sve do slučajeva kada query glasi "SELECT * FROM table WHERE clmn LIKE 'č%' " vraća i sve šta započinje s Č i E ????
Pomoć je dobrodošla!

Options: ReplyQuote


Subject
Views
Written By
Posted
koji character set
8716
March 04, 2009 03:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.