Tickets :: [#12769] Add mail contact - Illegal mix of collations

6.0.0-beta1

8/17/25

Summary	Add mail contact - Illegal mix of collations
Queue	Turba
Queue Version	4.1.2
Type	Bug
State	No Feedback
Priority	1. Low
Owners
Requester	samuel.wolf (at) wolf-maschinenbau (dot) de
Created	10/16/2013 (4323 days ago)
Due
Updated	03/08/2016 (3449 days ago)
Assigned	01/19/2016 (3498 days ago)
Resolved	03/08/2016 (3449 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

03/08/2016 10:55:48 AM	Jan Schneider	State ⇒ No Feedback

01/19/2016 05:18:03 PM	Jan Schneider	Comment #4 State ⇒ Feedback	Reply to this comment
Please provide the actual query too, which you should get with DEBUG logging.

01/13/2014 05:30:18 AM	asa (at) isac (dot) gov (dot) in	Comment #3	Reply to this comment
I am also getting this error in horde logs. Jan 13 2014 10:02:48 ERR: HORDE [imp] QUERY FAILED: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

10/16/2013 04:46:13 PM	Michael Slusarz	Version ⇒ 4.1.2 Queue ⇒ Turba

10/16/2013 10:12:46 AM	samuel (dot) wolf (at) wolf-maschinenbau (dot) de	Comment #2 New Attachment: character.png	Reply to this comment
Screenshot

10/16/2013 10:09:04 AM	samuel (dot) wolf (at) wolf-maschinenbau (dot) de	Comment #1 Priority ⇒ 1. Low Type ⇒ Bug Summary ⇒ Add mail contact - Illegal mix of collations Queue ⇒ IMP Milestone ⇒ Patch ⇒ No State ⇒ Unconfirmed	Reply to this comment
I want to add a mail contact with following special characters in the name: ? ? á IMP user see the red error box with the sql query error. horde.log: 2013-10-16T09:59:05+00:00 DEBUG: HORDE [turba] SQL QUERY FAILED: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' 2013-10-16T09:59:05+00:00 DEBUG: HORDE [imp] QUERY FAILED: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'