Re: [GENERAL] ascii() for utf8

Andrew Dunstan wrote:
> 
> Actually, I am working on this as part of the fixes for invalid encoding 
> stuff, as recently discussed.

OK, I have moved the item into the 8.3 queue.

---------------------------------------------------------------------------


> 
> cheers
> 
> andrew
> 
> Bruce Momjian wrote:
> > This has been saved for the 8.4 release:
> >
> >     http://momjian.postgresql.org/cgi-bin/pgpatches_hold
> >
> > ---------------------------------------------------------------------------
> >
> > Alvaro Herrera wrote:
> >   
> >> Decibel! wrote:
> >>     
> >>> Moving to -hackers.
> >>>
> >>> On Jul 27, 2007, at 1:22 PM, Stuart wrote:
> >>>       
> >>>> Does Postgresql have a function like ascii() that will
> >>>> return the unicode codepoint value for a utf8 character?
> >>>> (And symmetrically same for question chr() of course).
> >>>>         
> >>> I suspect that this is just a matter of no one scratching the itch. I 
> >>> suspect a patch would be accepted, or you could possibly put something on 
> >>> pgFoundry.
> >>>       
> >> Nay; there were some discussions about this not long ago, and I think
> >> one conclusion you could draw from them is that many people want these
> >> functions in the backend.
> >>
> >>     
> >>> I'd set it up so that ascii() and chr() act according to the 
> >>> appropriate locale setting (I'm not sure which one would be appropriate).
> >>>       
> >> I don't see why any of them would react to the locale, but they surely
> >> must honor client encoding.
> >>
> >> -- 
> >> Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
> >> "I dream about dreams about dreams", sang the nightingale
> >> under the pale moon (Sandman)
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 1: if posting/reading through Usenet, please send an appropriate
> >>        subscribe-nomail command to majordomo@postgresql.org so that your
> >>        message can get through to the mailing list cleanly
> >>     
> >
> >   

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +