Prevent characters not transposable to LATIN9

Поиск
Список
Период
Сортировка
От Arnaud Lesauvage
Тема Prevent characters not transposable to LATIN9
Дата
Msg-id 4C2A08A6.6080003@codata.eu
обсуждение исходный текст
Ответы Re: Prevent characters not transposable to LATIN9  (Sam Mason <sam@samason.me.uk>)
Список pgsql-general
Hi list !

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 ?

Thanks for any hints on this !

Regards
--
Arnaud Lesauvage

В списке pgsql-general по дате отправления:

Предыдущее
От: Jacqui Caren-home
Дата:
Сообщение: Re: Migrating from MySQL
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Fwd: Re: Weird trouble with select