Andreas Kalsch wrote: > My question again: Is there a native Postgres solution to simplify > characters consistently? It means to completely remove all > diacriticals from Unicode characters. There's a to_ascii() function but it supports a subset of charsets, and IIRC UTF8 is not one of them. Patches welcome. > I will validate input data on the client side (PHP or Python) and send > it to the server. Of course the only encoding I will use on any side > is UTF8. I just wnated to use this Latin thing for simplification of > characters. Hmm, seems you're using the wrong tool for that purpose. Changing to a different encoding does not remove any diacritical marks, only change the underlying byte encoding. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general