Re: [GENERAL] ascii() for utf8

Actually, I am working on this as part of the fixes for invalid encoding 
stuff, as recently discussed.

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
>>     
>
>