Re: How to find freak UTF-8 character? - Mailing list pgsql-general

From Cédric Villemain
Subject Re: How to find freak UTF-8 character?
Date
Msg-id CAF6yO=0eer+qEsiQrDT5DGf_23UaGBo3kGcqcpFLXeq+kkBp-g@mail.gmail.com
Whole thread Raw
In response to Re: How to find freak UTF-8 character?  (Leif Biberg Kristensen <leif@solumslekt.org>)
Responses Re: How to find freak UTF-8 character?  (Leif Biberg Kristensen <leif@solumslekt.org>)
List pgsql-general
2011/10/2 Leif Biberg Kristensen <leif@solumslekt.org>:
> On Sunday 2. October 2011 15.53.50 pasman pasmański wrote:
>> Its simple to remove strange chars  with regex_replace.
>
> True, but first you have to know how to represent a «strange char» in
> Postgresql :P
>
> It isn't all that obvious, and it's difficult to search for the solution. I
> tried a lot of different search terms in Google, and none of them turned up
> anything near what I needed.

you may have miss this one :
http://tapoueh.org/blog/2010/02/23-getting-out-of-sql_ascii-part-2.html


>
> regards, Leif
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation

pgsql-general by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: How to find freak UTF-8 character?
Next
From: Joe Abbate
Date:
Subject: Re: PL/Python