Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011

    Unanswered: Seaching for strings using hex constant

    Hi all,

    Some of the char varying columns in my database have single quotations entered as hex 92. I would like to change them to Hex 27 because the COPY command chokes when it hits them in a psql script.

    select name
    from school
    where name like '%' ||cast(x'92' as char) || '%'

    does not work to select the rows I need.

    Is there a way to do this in the database?



  2. #2
    Join Date
    May 2008
    Maybe the replace function?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts