XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. Xoops Development / 
  3. XOOPS Module Development
  4. Coding and Security Support 
  5.  / Question on "LIKE" Pattern Matching with UTF8?
Register
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
http://www.XoopsViet.com - Xoops for Vietnamese

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

145 user(s) are online (97 user(s) are browsing Support Forums)

Members: 0

Guests: 145

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits