List Info

Thread: error in utf8 subject string




error in utf8 subject string
user name
2006-12-26 20:49:21
Now I hit the "bug" with varchar instead bytea
also, I tried converting 
from cyrus to dbmail:

Copied msg id [5535] to folder Trash msg id 
[Mail::IMAPClient=HASH(0x85c485c)]
+ NO msg #5542 [gNIQIlv/cmNScU3El0/f8A] in Trash
+ Copying msg #5542:3654 to folder Trash
flags from : [NonJunk][" 3-Jul-2006 09:56:36
+0200"]
Couldn't append msg #5542 (Subject:
[openBC:=?UTF-8?Q?=20Best=C3=A4tigung=20Ihrer=20M?= 
=?UTF-8?Q?itgliedschaft=20in=20der=20?==?UTF-8?Q?Gruppe=20Wi
rtschaftsinf?= 
=?UTF-8?Q?o=20UNI=20?=/ TU Wien]) to folder
userg_wildmannTrash: NO Not 
connected.

An in the postgreSQL log (sorry, in german):
FEHLER:  ungültige Byte-Sequenz für Kodierung »UTF8«: 0xdf55
FEHLER:  aktuelle Transaktion wurde abgebrochen, Befehle
werden bis zum 
Ende der Transaktion ignoriert

Now I also believe that fields should be bytea. A simple
"alter table 
alter column" doesn't work, because
FEHLER:  Spalte »subjectfield« kann nicht in Typ »bytea«
umgewandelt 
werden

So no auto convert possible. Would anyone know a
"clean" way that 
doesn't mess up everything?

mfg zmi
-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                     
.network.your.ideas.
// PGP Key:        "curl -s http://zmi.at/zmi4.asc |
gpg --import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB  11B7 BA2D 060F
1C6F E6B0
// Keyserver: www.keyserver.net                   Key-ID:
1C6FE6B0
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )