Searching Problem In Myanmar Text Database

Hi!

I found a problem while retrieving/searching/filtering Myanmar Text with a Select Statement, In a Myanmar Text table there in a column called HeadWords.

It's Sample Data
HWID,HeadWords
1,|က|
2,|ကာ|
3,|ကိ|
4,|ကီ|
5,|ကဲ|

I want to make the following search:
SELECT * FROM TableName WHERE HeadWords LIKE '%|က|%' this should give me all entries that have a "|က|" *ANY* place in the HeadWords column. Right?

However, it gives me unproper results. you may see last two records have 2 characters between pipe(|).
HWID,HeadWords
1,|က|
3,|ကိ|
5,|ကဲ|

Since the wildcard character % means no or all characters it should work. And I've tried pipe, comma, forward slash and back slash.

The problem only seems to occur when the wildcard character is used for the any part of character. Let me know alternative way to search that matters. I've tried in MSAccess. There are same problem like MSSQL.

It's any problem in searching support for National Characters (UTF8). I've tried in OpenOffice Database with those data.
It's work fine.

If you not see Myanmar characters, please download fonts from http://www.fontmm.com/font_downloads.htm

Does anybody have an explanation to this, please let me know.

Thanks in advance!

Ngwe Tun