[balsa/imap-improvements] HTML preferences database: ensure lower-case mail addresses

[Albrecht Dreß <albrecht src gnome org>]

commit b07869a51e30d27e52437669e362c9192340cfdf
Author: Albrecht Dreß <albrecht dress netcologne de>
Date:   Mon May 17 19:15:31 2021 +0200

    HTML preferences database: ensure lower-case mail addresses
    
    Fix html preferences not being recognised if the mail address contains
    upper-case characters: ensure the address is stored in lower-case.
    
    Signed-off-by: Albrecht Dreß <albrecht dress netcologne de>

 libbalsa/html-pref-db.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/libbalsa/html-pref-db.c b/libbalsa/html-pref-db.c
index d16d285af..70d8fdda1 100644
--- a/libbalsa/html-pref-db.c
+++ b/libbalsa/html-pref-db.c
@@ -221,9 +221,9 @@ pref_db_check(void)
 {
        static const gchar * const prepare_statements[NUM_QUERIES] = {
                "SELECT * FROM html_prefs WHERE addr = LOWER(?)",
-               "INSERT INTO html_prefs (addr, prefer_html) VALUES (?1, ?2) "
+               "INSERT INTO html_prefs (addr, prefer_html) VALUES (LOWER(?1), ?2) "
                                "ON CONFLICT (addr) DO UPDATE SET prefer_html = ?2",
-               "INSERT INTO html_prefs (addr, prefer_load_img) VALUES (?1, ?2) "
+               "INSERT INTO html_prefs (addr, prefer_load_img) VALUES (LOWER(?1), ?2) "
                                "ON CONFLICT (addr) DO UPDATE SET prefer_load_img = ?2",
                "DELETE FROM html_prefs WHERE addr = LOWER(?1)",
                "SELECT addr, prefer_html, prefer_load_img FROM html_prefs ORDER BY addr ASC"