var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Seaching for strings using hex constant
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.
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?
Maybe the replace function?