Re: searching for characters via the hexidecimal value

On 2011-01-24, Geoffrey Myers <lists(at)serioustechnology(dot)com> wrote:
> Massa, Harald Armin wrote:
>
> 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';
>

you can do hex like this:

select comments from fax where comments ~* E'\x99';

or if your hex is unicode

select comments from fax where comments ~* U&'\2122';

http://www.postgresql.org/docs/8.4/static/sql-syntax-lexical.html

--
⚂⚃ 100% natural