Обсуждение: Can you check in SQL if a fields can be encoded using specified charset

Поиск
Список
Период
Сортировка

Can you check in SQL if a fields can be encoded using specified charset

От
Paul Taylor
Дата:
Is there a function that can say whether a textvalue can be encoded in a
particular charset

i.e.

SELECT FIELD1 FROM TABLE1 WHERE ENCODE_AS_IS08859(FIELD1)=true

thanks Paul

Re: Can you check in SQL if a fields can be encoded using specified charset

От
Dimitri Fontaine
Дата:
Paul Taylor <paul_t100@fastmail.fm> writes:

> Is there a function that can say whether a textvalue can be encoded in a
> particular charset

See convert() and friends here:

  http://www.postgresql.org/docs/9.0/interactive/functions-string.html#FUNCTIONS-STRING-OTHER

That will issue an error when the text can't be converted, but you could
have a plpgsql function catching the exception for you and returning
false. Won't be very fast, but will do the job.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support