Search for special character like é in informix

[kalpanapai]

What needs to be set in informix for searching keywords like café .
if we give sql as
select * from test where name matches '*mycafé*'
or select * from test where name matches '*café*'
it does not work but it works with
select * from test where name matches '* café*'
select * from test where name matches '*mycafé'

We have setting on the server as follows

LC_COLLATE=en_US.ISO8859-1
LC_CTYPE=en_US.ISO8859-1
LC_MESSAGES=C
LC_MONETARY=en_US.ISO8859-1
LC_NUMERIC=en_US.ISO8859-1
LC_TIME=en_US.ISO8859-1
Any clues appreciated

Thanks in Advance

 

[kalpanapai]

I'd like to know if is it possible only to get a defined range of rows from informix .
That is, I'd want to recover rows from number 1 to 50 the first time, from number 51 to 100 the second time, from 101 to 150 the third time, and so on...
from the java application, and display per page so that it will limit the resource usage per session if query reteuns more rows.

MySQL has a LIMIT clause for that purpose and SET ROWCOUNT in MYsql

I would really appriciate any suggestions and ideas
Thanks & regards