SpamExperts
diff --git a/‎MySQLdb/_mysql.c
Copy file name to clipboardExpand all lines: MySQLdb/_mysql.c
+3Lines changed: 3 additions & 0 deletions b/‎MySQLdb/_mysql.c
Copy file name to clipboardExpand all lines: MySQLdb/_mysql.c
+3Lines changed: 3 additions & 0 deletions
diff --git a/‎MySQLdb/connections.py
Copy file name to clipboardExpand all lines: MySQLdb/connections.py
+9-4Lines changed: 9 additions & 4 deletions b/‎MySQLdb/connections.py
Copy file name to clipboardExpand all lines: MySQLdb/connections.py
+9-4Lines changed: 9 additions & 4 deletions
@@ -217,6 +217,9 @@ _get_encoding(MYSQL *mysql)
     if (strncmp(utf8, cs.csname, 4) == 0) { // utf8, utf8mb3, utf8mb4
         return utf8;
     }
+    else if (strncmp("latin1", cs.csname, 6) == 0) {
+        return "cp1252";
+    }
     else if (strncmp("koi8r", cs.csname, 5) == 0) {
         return "koi8_r";
     }
 
@@ -15,6 +15,14 @@
     NotSupportedError, ProgrammingError,
 )
 
+# Mapping from MySQL charset name to Python codec name
+_charset_to_encoding = {
+    "utf8mb4": "utf8",
+    "utf8mb3": "utf8",
+    "latin1": "cp1252",
+    "koi8r": "koi8_r",
+    "koi8u": "koi8_u",
+}
 
 re_numeric_part = re.compile(r"^(\d+)")
 
@@ -289,10 +297,7 @@ def set_character_set(self, charset):
         set can only be changed in MySQL-4.1 and newer. If you try
         to change the character set from the current value in an
         older version, NotSupportedError will be raised."""
-        if charset in ("utf8mb4", "utf8mb3"):
-            py_charset = "utf8"
-        else:
-            py_charset = charset
+        py_charset = _charset_to_encoding.get(charset, charset)
         if self.character_set_name() != charset:
             try:
                 super(Connection, self).set_character_set(charset)
Original file line number	Diff line number	Diff line change
`@@ -217,6 +217,9 @@ _get_encoding(MYSQL *mysql)`
`217`	`217`	`if (strncmp(utf8, cs.csname, 4) == 0) { // utf8, utf8mb3, utf8mb4`
`218`	`218`	`return utf8;`
`219`	`219`	`}`
	`220`	`+ else if (strncmp("latin1", cs.csname, 6) == 0) {`
	`221`	`+ return "cp1252";`
	`222`	`+ }`
`220`	`223`	`else if (strncmp("koi8r", cs.csname, 5) == 0) {`
`221`	`224`	`return "koi8_r";`
`222`	`225`	`}`