paul at nfg
Apr 9, 2008, 2:24 AM
Post #2 of 2
(198 views)
Permalink
|
Sim Zacks wrote:
> dbmail 2.2.7
> We have been using MySQL (we just realized ISAM tables) and are
> migrating to Postgresql.
ISAM, yuk. I hope you mean MYISAM, because ISAM tables are deprecated in mysql.
And for dbmail you should definitely at the very least switch to INNODB because
of the foreign key contraints. Of course moving to postgres is also a good
alternative.
>
> We noticed that when we search using Thunderbird, that if it searches
> the message body it is case-sensitive. Is there a way to make the search
> case-insensitive?
Not for postgres. The body parts are stored in BYTEA columns, and those cannot
match case-insensitive with the current setup (which uses a HAVING LIKE clause).
This limitation in postgres cascaded to the other drivers.
Of course, a full-text index setup would probably solve this, but that's not
exactly on the top of my todo list. I'm not even sure it's doable given that the
native drivers have been replaced by libzdb in the trunk code.
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
