Re: searching for characters via the hexidecimal value

Поиск
Список
Период
Сортировка
От Massa, Harald Armin
Тема Re: searching for characters via the hexidecimal value
Дата
Msg-id AANLkTinyE5v2NgQ=BbQjw4tth=wGpMC0SnK1p6H5TArH@mail.gmail.com
обсуждение исходный текст
Ответ на searching for characters via the hexidecimal value  (Geoffrey Myers <lists@serioustechnology.com>)
Ответы Re: searching for characters via the hexidecimal value
Список pgsql-general
Дерево обсуждения
yes, there is.

select <your columns> from <your table> where

<your_text_search_column> like '%'||chr(x'42'::int)||'%'

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@serioustechnology.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@postgresql.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

В списке pgsql-general по дате отправления: