Re: How to find freak UTF-8 character?

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to find freak UTF-8 character?
Date: 2011-10-02 16:09:39
Message-ID: 201110021809.39771.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday 2. October 2011 17.54.52 Raymond O'Donnell wrote:
> I may have missed it upthread, but if you haven't already would you
> consider writing up your solution for the benefit of the archives?

I did, in my own first reply to the original message:

SELECT * FROM foo WHERE bar LIKE E'%\xe2\x80\x8e%';

The trick is obviously to escape each byte in the sequence.

Maybe I'll write a blog post about it. It appears to be weakly documented, or
at least very hard to find. Or maybe it's just me being dense.

regards, Leif.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2011-10-02 16:44:21 Re: Updating 9.0.4 --> 9.1.1: How best to ???
Previous Message Raymond O'Donnell 2011-10-02 15:54:52 Re: How to find freak UTF-8 character?