> Is it possible to configure PostgreSQL so that a " LIKE 'a' " query > will match a 'รก' value, ie, make it accent-insensitive ?
I forgot this was possible using regular expressions. I don't think it is possible using the LIKE syntax. if you use something like: select * from yourtable where yourstring ~ '[=e=]'; http://www.postgresql.org/docs/8.2/interactive/functions-matching.html#POSIX-BRACKET-EXPRESSIONS Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
