| From: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Prevent characters not transposable to LATIN9 |
| Date: | 2010-07-01 14:48:27 |
| Message-ID: | 20100701144826.GG7584@samason.me.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jun 29, 2010 at 04:52:22PM +0200, Arnaud Lesauvage wrote:
> We have a database in UTF8, from which we have to export text files in
> LATIN9 encoding (or WIN1252, which is almostthe same I believe).
>
> Records are entered via MSAccess forms (on psqlodbc-linked tables).
> The problem is that some of the characters input by the users have no
> equivalent in LATIN9.
>
> How could I easily write a CONSTRAINT (or RULE) that would check that
> everything entered in the fields have an equivalent in my specific
> destination encoding ?
How about using the built in character conversion routines. Something
like:
col = convert_from(convert_to(col, 'LATIN9'),'LATIN9')
as the check constraint, or its inverse as the where clause for the
erroneous rows?
--
Sam http://samason.me.uk/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnaud Lesauvage | 2010-07-01 14:53:51 | Re: Prevent characters not transposable to LATIN9 |
| Previous Message | aaaawwww | 2010-07-01 14:43:45 | problems with encoding and accent letters |