From: | Gianni Mariani <gianni(at)mariani(dot)ws> |
---|---|
To: | "Psql_General (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Binary data |
Date: | 2003-06-30 16:09:20 |
Message-ID: | 3F0060B0.4030304@mariani.ws |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I was testing dbmail with a Postgresql backend and I ran into an issue
I have with encoding. Dbmail is a database driven email store.
I normally create my databases using the UNICODE encoding. However when
I attempted to transfer email from another imap server, the insert
failed with an "invalid charcter" with a message that obviously
contained an invalid sequence for utf-8 (I suspect).
The table in question is:
Table "messageblks"
Column | Type |
Modifiers
-----------------+--------+-------------------------------------------------------
messageblk_idnr | bigint | not null default
nextval('messageblk_idnr_seq'::text)
message_idnr | bigint | not null default '0'
messageblk | text | not null
blocksize | bigint | not null default '0'
What would be the appropriate type for messageblk ? I was thinking bytea.
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah | 2003-06-30 16:09:23 | Re: Making pgsql error messages more developers' friendly. |
Previous Message | nolan | 2003-06-30 15:25:32 | Possible parsing problem? |