access database select unicode error in vc++

See more:

VC6

C++

SQL

MS-Access

Unicode

the data in access db is this:

download demo code:http://files.cnblogs.com/songtzu/ADO.rar[^]

m_Conn.SetConnectionString("Provider=Microsoft.Jet.OLEDB.4.0; Data Source= TestDb.mdb;Jet OLEDB:DataBase password=1314;");
m_Conn.Open("","","",ConnectOption::adConnectUnspecified);
m_Cmd.SetActiveConnection(m_Conn);

my db connect code is this:


Email

yangxb@126.com
chenki@163.com
Liugob@126.com333
Tangyl@yahoo.com
Zhangzd@hotmail.com
dfgd@eter.com
中文邮箱@gmail.com
中文邮箱@gmail.com
try@gmail.com

I trid to use "select like " to get "try@gmail.com"
here is my vc++ code:
m_Cmd.SetCommandText("select * from Phone where Email LIKE '%try%' ");
it would prompt "not data found"


if I try to select the first unicode text "中文邮箱@gmail.com" by this:
m_Cmd.SetCommandText("select * from Phone where Email LIKE '%中文%' ");

It has right result.Is this access's bug?