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
> -Original Message-
> From: Austin Ziegler [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 04, 2005 2:12 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] International Language Support
[snip]
> If you're compiling with UNICODE and are using TCHAR*, you
[04-08-2005 21:31, Dan Wellisch escreveu]
We just put a SQLlite application in production. It handles the display
of ISO 8859-1characters just fine if they appear in the search
results.
Please bear in mind that sqlite3 expects UTF-8 input, not ISO8859-1, so
you need to make sure you convert e
Hi Dan,
I think we need to know this here:
How do your SELECT statements look like?
What's the keyword your international clients use - to find what data?
And what's the data in the table?
What might be already a help is:
" The LIKE operator is not case sensitive and will match upper case
ch
On 8/4/05, Dan Wellisch <[EMAIL PROTECTED]> wrote:
> Are you saying that 8859-1 encoding does not work with these
> international versions of MS Windows, so we would need to ensure
> that we are putting UTF-8 chars in the data? This would make sense
> if the OS uses UTF-8 chars. in the WHERE clause
Austin:
Are you saying that 8859-1 encoding does not work with these
international versions of MS Windows, so we would need
to ensure that we are putting UTF-8 chars in the data? This would make
sense if the OS uses UTF-8 chars. in the WHERE
clause so that it is searching against 8859-1 chars.
On 8/4/05, Dan Wellisch <[EMAIL PROTECTED]> wrote:
> We just put a SQLlite application in production. It handles the
> display of ISO 8859-1characters just fine if they appear in the
> search results.
>
> However, users that are running German, French, etc. versions of
> Microsoft Windows are comp
Hello:
We just put a SQLlite application in production. It handles the display
of ISO 8859-1characters just fine if they appear in the search
results.
However, users that are running German, French, etc. versions of
Microsoft Windows are complaining that search results are coming
back with 0
8 matches
Mail list logo
