From: | Geoffrey Myers <lists(at)serioustechnology(dot)com> |
---|---|
To: | "Massa, Harald Armin" <chef(at)ghum(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: searching for characters via the hexidecimal value |
Date: | 2011-01-24 15:43:37 |
Message-ID: | 4D3D9E29.5070303@serioustechnology.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Massa, Harald Armin wrote:
> yes, there is.
>
> select <your columns> from <your table> where
>
> <your_text_search_column> like '%'||chr(x'42'::int)||'%'
This does not work for me, but if I convert the hex value to octal this
does work:
select comments from fax where comments ~* E'\231';
>
> where '42' is your hexadecimal character value.
>
> Be sure to read and understand everything you can find about encodings;
> and make sure the hexadecimal value you are searching for is from the
> same encoding.
>
> Best wishes,
>
> Harald
>
> On Mon, Jan 24, 2011 at 16:00, Geoffrey Myers
> <lists(at)serioustechnology(dot)com <mailto:lists(at)serioustechnology(dot)com>> wrote:
>
> Is there a way to search for a character in the database by the
> hexidecimal value of that character?
>
> --
> Until later, Geoffrey
>
> "I predict future happiness for America if they can prevent
> the government from wasting the labors of the people under
> the pretense of taking care of them."
> - Thomas Jefferson
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
>
> --
> GHUM GmbH
> Harald Armin Massa
> Spielberger Straße 49
> 70435 Stuttgart
> 0173/9409607
>
> Amtsgericht Stuttgart, HRB 734971
> -
> persuadere.
> et programmare
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
From | Date | Subject | |
---|---|---|---|
Next Message | Fredric Fredricson | 2011-01-24 15:50:33 | (Hopefully stupid) select question. |
Previous Message | Massa, Harald Armin | 2011-01-24 15:15:51 | Re: searching for characters via the hexidecimal value |