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 didn't find anything in the docs so I think the answer
is no which leads me to ask... Why not? (Hard to believe
lack of need without concluding that either ascii() is
not needed, of utf8 text is little used.)

Are there technical problems in implementing such a
function? Has anyone else already done this (ie, is
there somewhere I could get it from?)

Is there some other non-obvious way to get the cp value
for the utf8 character?

I think I could use plperl or plpython for this but
this seems like an awful lot of overhead for such a
basic task.



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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 didn't find anything in the docs so I think the answer
> is no which leads me to ask... Why not? (Hard to believe
> lack of need without concluding that either ascii() is
> not needed, of utf8 text is little used.)
>
> Are there technical problems in implementing such a
> function? Has anyone else already done this (ie, is
> there somewhere I could get it from?)
>
> Is there some other non-obvious way to get the cp value
> for the utf8 character?
>
> I think I could use plperl or plpython for this but
> this seems like an awful lot of overhead for such a
> basic task.

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. 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).
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/