Hi, at my tests with svn 2192 and postgresql I find out that there is a huge diff if you install dbmail with mysql or postgresql. In postgresql the SQL operators "=" and "LIKE" are case-sensitive, so a simple search over headerfields failed for me because e.g. the header "subject" is saved in the database as "Subject", but thunderbird (and dbmail) make a select with "SUBJECT". Is there a plan to adapt database typical differences in near future? ( C is not my lanuage, so I have some problems to provide source, what I'm thinking about is to replace the compare operators in SQL-selects with an variable that is filled with the best matched operator for this DB.
e.g. for text-compare: MySQl "=" should be "~*" in PostgreSQL MySQL "LIKE" should be "ILIKE" in PostgreSQL Kind regards, Jochen -- ECS-Solution GmbH Raiffeisenstr. 26 67817 Imsbach Germany Web: http://www.ecs-solution.de Tel: +49 (6302) 609 71-0 Fax: +49 (6302) 609 71-1
