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?
|
Список | 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 по дате отправления: