I appreciate all who contributed their time and knowledge to this
issue. The information that I failed to give to all of you is that
we are issuing our SELECT statements such that all expressions in our
WHERE clause are ids. The only exception is zipcode.
I found the problem to be that since our app. is a wxWidgets app. and I
am using a locale object to specify locale, I found that
I must specify the locale to ENGLISH instead of letting the locale
default to the machine's locale. I can't pinpoint the exact location
of what happens, whether it is in the interaction between wxWidgets code
with calls to SQLite libraries or whether it is within
the SQLite libraries themselves.
At this point, it is not important as the problem is fixed by keeping
the locale in ENGLISH. This still allows us to display the
ISO 8859-1 data in our tables properly and it is working correctly.
I believe the various comments from people suggesting that we should use
UTF-8 characters versus ISO-8859 characters came from
the assumption that the user was inputing data that might be used in a
SQL WHERE clause. This; however, as stated above,
is not the case.
Thanks again for your attention.
Dan Wellisch
