Diego Manilla Suárez wrote: > Hi. I have a few databases created with UNICODE encoding, and I would > like to be able to search with accent insensitivity. There's something > in Oracle (NLS_COMP, NLS_SORT) and SQL Server (don't remember) to do > this, but I found nothing in PostgreSQL, just the 'to_ascii' function, > which AFAIK, doesn't work with UNICODE.
to_ascii() doesn't work with UTF-8, but you can use convert() to turn the UTF8 text into Latin-1 and then use to_ascii() to remove the funny bits. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match