[balsa/imap-improvements] HTML preferences database: ensure lower-case mail addresses
- From: Albrecht Dreß <albrecht src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [balsa/imap-improvements] HTML preferences database: ensure lower-case mail addresses
- Date: Mon, 17 May 2021 17:15:30 +0000 (UTC)
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"
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]