tvn3015
Just popping in
Posted on: 2009/5/5 4:12
#1
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
Question on "LIKE" Pattern Matching with UTF8?
2009/5/5 4:12 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
http://www.XoopsViet.com - Xoops for Vietnamese