From: | tom <tom(at)tacocat(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | text storage and parsing errors |
Date: | 2007-01-28 22:10:03 |
Message-ID: | 7D8C70FE-EDC7-4A90-9E0B-6DAE9CA553E7@tacocat.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
For what may be really strange reasons I am trying to store emails
into a database table. The idea is to take the entire original
message and store it into a table with two columns, an serial primary
key column and a column for the message.
Originally I thought I would just use column type text but changed
that to bytea based on the fact that the dbmail project uses bytea
for reasons of character support.
I'm running into problems with perl throwing an error of :'invalid
input syntax for type bytea'.
I have not yet been able to capture a message for any further testing
because the error tends to destroy the message in process...
the way that I'm using perl is to do a full prepare and execute
statements, which as I understand perl, will do all the character
escaping necessary to store the message. meaning, If I have
characters like (') or (`) they should be escaped when they are
entered into the SQL parameter. I am wondering if this is indeed the
case.
But I'm looking for any suggestions or considerations when trying to
d this approach to avoid this kind of text parsing problem.
From | Date | Subject | |
---|---|---|---|
Next Message | Ing. Martin Prášek | 2007-01-28 22:15:52 | MULE_INTERNAL translation to win1250 |
Previous Message | Andrus | 2007-01-28 21:46:27 | How to allow users to log on only from my application not from pgadmin |