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 <li...@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
