ISFDB Bibliographic Tools / Bugs / #751 Searches for magazine titles with accented characters error out

#751 Searches for magazine titles with accented characters error out

Milestone: v1.0 (example)

Status: closed-fixed

Owner: Ahasuerus

Labels: None

Priority: 5

Updated: 2020-05-04

Created: 2020-04-19

Creator: Ahasuerus

Private: No

A search for a magazine with "récréa" in its title results in the following Python error:

<class '_mysql_exceptions.operationalerror'="">: (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'") </class>

Discussion

Ahasuerus - 2020-05-04

status: open --> closed-fixed

assigned_to: Ahasuerus
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Ahasuerus - 2020-05-04

Fixed in common/SQLparsing.py. Installed in SVN 518 on 2020-05-04. Closing the Bug.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous

Searches for magazine titles with accented characters error out

Group

Searches

Help

#751 Searches for magazine titles with accented characters error out

Discussion