Re: encoding question

I don't think you see what I mean :)

I want to display the data on a webpage to the user.  This means that a
varchar containing the string "I don't want it", should not appear as "I
don''t want it".  So pg_escape_string isn't used there.  bytea is different
tho because the default display isn't terribly useful...

Chris

----- Original Message ----- 
From: "Rod Taylor" <rbt@rbt.ca>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: "Hackers" <pgsql-hackers@postgresql.org>
Sent: Thursday, August 07, 2003 9:46 AM
Subject: Re: [HACKERS] encoding question

> My other question is we play around with bytea fields to escape nulls and
> chars < 32 and stuff so that when someone browses the table, they get
> '\000<unknown>\000...', etc.  However, are the other field types for which
> we have to do this?  Can you put nulls and stuff in text/varchar/char
> fields?  What about other fields?

pg_escape_string
pg_escape_bytea

Escape everything :)