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

2010-11-17 Thread Dimitri Fontaine
Paul Taylor 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 con

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

2010-11-12 Thread 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po