| From: | Ennio-Sr <nasr(dot)laili(at)tin(dot)it> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Cc: | nasr(dot)laili(at)tin(dot)it |
| Subject: | Re: how to ignore accents? |
| Date: | 2005-04-02 16:45:04 |
| Message-ID: | 20050402164503.GA2110@deby.ei.hnet |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
* Ennio-Sr <nasr(dot)laili(at)tin(dot)it> [020405, 16:11]:
> * Michael Fuhr <mike(at)fuhr(dot)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) ]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-04-02 17:35:21 | Re: Boolean search |
| Previous Message | Ennio-Sr | 2005-04-02 14:11:41 | Re: how to ignore accents? |