[GENERAL] LATIN1 encoding

Hello !! Can i configure a table or an entire database to use LATIN1 ascii encoding? Instead of using to_ascii(field,'LATIN1') every time? Thank you ! ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

[GENERAL] Accent insensitive search

Hi ! Does anyone knows how to make accent insensitive searches?? For example i have this data in a table Colón Polo I need that this query SELECT * FROM testtable WHERE testfield like '%olo%'; brings both results instead of only showing Polo. Thanks in advance!