[GENERAL] Problem of capital case-insensitive letter with accent

2008-01-21 Thread lan ping
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,

Re: [GENERAL] Problem of capital case-insensitive letter with accent

2008-01-21 Thread lan ping
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? > >