Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group