Paul Taylor <paul_t100(at)fastmail(dot)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