Re: how to ignore accents?

Поиск
Список
Период
Сортировка
От Ennio-Sr
Тема Re: how to ignore accents?
Дата
Msg-id 20050402164503.GA2110@deby.ei.hnet
обсуждение исходный текст
Ответ на Re: how to ignore accents?  (Ennio-Sr <nasr.laili@tin.it>)
Ответы Re: how to ignore accents?  (Ennio-Sr <nasr.laili@tin.it>)
Список pgsql-novice
* Ennio-Sr <nasr.laili@tin.it> [020405, 16:11]:
> * Michael Fuhr <mike@fuhr.org> [010405, 18:41]:
> > On Fri, Apr 01, 2005 at 08:36:35PM +0200, Ennio-Sr wrote:
> > >
> > >       RETURN translate($1, ''\342\347\350\351\352\364\373'', ''aceeeou'');
> > >
> Now it works greatly! ..... :-)

Sorry, I forgot to ask this in my previous post:
Is there a better way to see all the codes used by postgres to map
characters than trying them one by one?
I mean: where should I look for to have a map similar to the one I get
running (from a linux console):
$ ascii     ????

I tried with unicode but was unable to find any correspondence between,
say, _\350_ and _è_.
Both googling around and looking into the /usr/share/docs didn't help much...

Regards,
    Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.   \\?//
 Fa' qualche cosa di cui non sei capace!"  (diceva Henry Miller) ]    (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that.              )=(
 Do something you aren't good at!" (as Henry Miller used to say) ]

В списке pgsql-novice по дате отправления:

Предыдущее
От: Ennio-Sr
Дата:
Сообщение: Re: how to ignore accents?
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Boolean search