ideq Posted February 20, 2011 Report Share Posted February 20, 2011 Labdien! :D Atvainojos par manu lv. valodu. Man ir problema, man ir vardu baze un es gribu nemt vardus pa pirmo burtu. $this->db->getAssocList("SELECT * FROM `names` WHERE `gender`='F' && SUBSTRING(name, 1,1) ='" . $letter); AR LIKE tapat ka ar Substring Bet mysql doma, ka A un Ā ir viena burte. Bazes encoding: utf8_general_ci Varbut jus zinat, kur ir problema? Paldies Quote Link to comment Share on other sites More sharing options...
daGrevis Posted February 20, 2011 Report Share Posted February 20, 2011 Labs jautājums. Kā 'A' var būt 'Ā'? Quote Link to comment Share on other sites More sharing options...
ideq Posted February 20, 2011 Author Report Share Posted February 20, 2011 up :< Quote Link to comment Share on other sites More sharing options...
marcis Posted February 20, 2011 Report Share Posted February 20, 2011 http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-sets.html aka lieto utf8_latvian_ci Quote Link to comment Share on other sites More sharing options...
ideq Posted February 20, 2011 Author Report Share Posted February 20, 2011 SELECT * FROM `names` WHERE `gender`='F' && BINARY SUBSTRING(name, 1,1) = 'Ā' tagad ir ok. utf8_latvian_ci nedarbo Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.