[SQL] Unescaping text or binary file

2008-01-14 Thread RDyes
IN your sql statements you use e to escape data going into a binary, or text field. How do you unescape this same data? Richmond H. Dyes Monroe Community Hospital 760-6213

[SQL] How to escape a memo field as a binary value in postgresql

2007-10-12 Thread rdyes
I want to take the value of my memo field in Paradox and insert/update the value of a binary field in my backend postgresql database. How would I write this sql statement for the sake of this example lets say the field name is pmemo in paradox and the is bymemo a bytea field in Postgresql dat