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

From: Paul Taylor <paul_t100(at)fastmail(dot)fm>
To: pgsql-general(at)postgresql(dot)org
Subject: Can you check in SQL if a fields can be encoded using specified charset
Date: 2010-11-12 15:27:41
Message-ID: 4CDD5CED.9020408@fastmail.fm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Mitchell 2010-11-12 15:38:03 Re: More then 1600 columns?
Previous Message Elford,Andrew [Ontario] 2010-11-12 14:45:21 Re: Help in Getting Started