Hi, there
In our database, some customers' names contain French accent like
É,é,È,è. In one server, case-insensitive search works for capital letters. For
example,
SELECT lower('ÉÈ') could return éè . But the other server cannot.
It is very strange, as the two server use the same Fedora linux,
Yes. I'm sure that we are using LATIN1 on both. ServerA works, but ServerB not.
We changed the local of ServerA(as it is a testing server) the same as ServerB,
but ServerA still works. Quite strange.
Pavel Stehule <[EMAIL PROTECTED]> wrote: Hello
> Are you sure you're using LATIN1 on both?
>
>