Capital letters

[Anon]

I have a database in PostgreSql, when I search for a word I can't find it if the word is in capital letters or if it has accents. Ex.
(select * from table1 where name="jardin")
it can find "jardin" but not "Jardin" or "jardín". How can I avoid accents and capital letters?
Thank you.

[Anon]

use ~* for case INsensitive regex, i.e.

(select from table1 where name ~ "jardin")

will find"Jardin" , "JARDIN", "jArDIn" etc.

Database Character encoding does matter.

regards