Re: Full text index without accents
От | Jonathan Bond-Caron |
---|---|
Тема | Re: Full text index without accents |
Дата | |
Msg-id | 000301c8ee68$0be86c10$23b94430$@com обсуждение исходный текст |
Ответ на | Re: Full text index without accents (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Ya the function name norm_text_latin() was probably misleading, it takes latin1-ish characters *encoded in UTF8* and brings them to ascii. Definitely, the following would be much simpler: SELECT to_ascii('ÀÁÂÃÄÅÒÓÔÕÖ', 'UTF8') As of 8.3, you have to do some magic with to_ascii() and utf8 characters SELECT to_ascii(convert_to_latin('ÀÁÂÃÄÅÒÓÔÕÖ'), 'LATIN1') -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane Sent: July 25, 2008 10:42 AM To: Alvaro Herrera Cc: Jonathan Bond-Caron; 'Fco. Mario Barcala Rodríguez'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Full text index without accents Alvaro Herrera <alvherre@commandprompt.com> writes: > Hmm, why not simply use to_ascii() ? The big problem with to_ascii is its inadequate set of supported encodings. Somebody *really* needs to give it some love on that front. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: