Searching with Chinese

Environment:
English WinXP, English Office 2000, English Access 2002

Background:
I’m trying to program a button to return the number of records that match a certain criteria. The criteria is specified in Chinese characters.

Symptoms:
The result returns 0 matching record when clearly there is 2 records matching the criteria. A debug and subsequent print out of the sql statement seem to be correct but the result is returned wrongly. The same testing application worked in English Win98, English Office 2000 and Richwin. I suspect it is the introduction of Unicode to represent Chinese characters that is causing the problem but I’m not sure.

I can email by test Access Database to anyone that is interested. thanks

Please post your SQL statement here and let us look at what it says. We understand that the Chinese characters may be doing something, but I just want to see if the basic syntax is correct first before we move on to blaming unicode. Thanks.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division