On 2011-01-24, Geoffrey Myers <lists@xxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
