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

Re: Détecter les TEXT c?==?iso-8859-1?Q?ontenant des caractères non-ASCII

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: Daniel Verite <daniel(at)manitou-mail(dot)org>
Cc: pgsql-fr-generale(at)postgresql(dot)org
Subject: Re: Détecter les TEXT c?==?iso-8859-1?Q?ontenant des caractères non-ASCII
Date: 2009-04-06 07:48:33
Message-ID: 20090406074833.GA13968@nic.fr (view raw or flat)
Thread:
Lists: pgsql-fr-generale
On Mon, Apr 06, 2009 at 09:27:17AM +0200,
 Daniel Verite <daniel(at)manitou-mail(dot)org> wrote 
 a message of 15 lines which said:

> Je crois que tu peux utiliser: octet_length(chaine) > length(chaine)

Très astucieux et ça marche, merci beaucoup.

dnsmezzo=> select id,qname from dns_packets where octet_length(qname) > length(qname);
    id     |                 qname    
...
 121511495 | télé2.fr


In response to

pgsql-fr-generale by date

Next:From: damien@dalibo.infoDate: 2009-04-06 08:08:21
Subject: Travaux sur la plateforme postgresql.fr, mardi 7 avril
Previous:From: Daniel VeriteDate: 2009-04-06 07:27:17
Subject: Re: Détecter les TEXT contenant des caractères non-ASCII

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