to_ascii() - Mailing list pgsql-patches

From Karel Zak
Subject to_ascii()
Date
Msg-id Pine.LNX.3.96.1000804151847.13077G-101000@ara.zf.jcu.cz
Whole thread Raw
Responses Re: to_ascii()
List pgsql-patches
 to_ascii( text )

    - encode 'text' from database encoding to ASCII

    to_ascii('\256\341k')


 to_ascii( text, int4 )

    - encode 'text' from 'int4' encoding to ASCII

       to_ascii('\256\341k', 8)


 to_ascii( text, name )

    - encode 'text' from 'name' encoding to ASCII

      to_ascii('\256\341k', 'LATIN2')


  Now is supported LATIN1, LATIN2, WIN1250. For other character sets I
haven't good resources. Add new encoding is easy...

 If encoding is not supported returns ERROR.

 Note --- not exists total corect conversion to ASCII, this function try
    convert chars those is _probably_ interpret-able in ASCII for
    others use ' '. But for example for all Czech characters it is
    sufficient ... hmm Chinese / JAP and other complicated langs have
    bad luck here :-(

                        Karel

Attachment

pgsql-patches by date:

Previous
From: Stephan Szabo
Date:
Subject: Some Foreign Key fixes
Next
From: Bruce Momjian
Date:
Subject: Re: to_ascii()