Jorge Bastos wrote: > Can someone tell me something about this? > > Jorge > > ----- Original Message ----- > *From:* Jorge Bastos <mailto:[EMAIL PROTECTED]> > *To:* DBMail mailinglist <mailto:[email protected]> > *Sent:* Wednesday, May 03, 2006 12:20 AM > *Subject:* [Dbmail] Charset and Collation > > Paul, > > I Don't know if this part is you that take care of it but there it goes... > I don't know if you remember i said something about charset. > So...i have the database set to charset=utf8 and > collation=utf8_general_ci and all tables and their fields set to the > same, before it i had charset=latin1 & collation=latin1_swedish_ci.
So you did: ALTER TABLE dbmail_messageblks MODIFY messageblk LONGBLOB NOT NULL; ALTER TABLE dbmail_messageblks MODIFY messageblk LONGTEXT NOT NULL CHARACTER SET utf8; as described in the mysql manual section 10.10.2 right? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
