1
tvn3015
Question on "LIKE" Pattern Matching with UTF8?
  • 2009/5/5 4:12

  • tvn3015

  • Just popping in

  • Posts: 53

  • Since: 2007/4/18


Hi,

I am using "LIKE" pattern matching to list all tilte string begining with an alphabetical letter such as A, B etc... using this code
SELECT * FROM tname WHERE string LIKE 'A%' it works great and return all strings begining with "A". But when matching with a UTF8 character such as Ă, Â, Ô, Ơ, Đ, Ư the query đidn't return anything eventhough there are some strings that begining with those letters.

Please help! Thanks
hhttp://www.XoopsViet.com - Xoops for Vietnamese