---
title: "Illegal mix of collations..."
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/164535-illegal-mix-of-collations"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Travoni"
published: "2007-09-15T14:19:25.000Z"
updated: "2007-09-17T13:48:17.000Z"
replies: 3
views: 552
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/164535-illegal-mix-of-collations"
---

# Illegal mix of collations...

## #1 — Travoni, 2007-09-15T14:19Z

Hur undviker jag detta?

> **mySql skrev:**
>
> Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation

Permalänk: https://www.webforum.nu/p/164535

## #2 — aasah, 2007-09-16T19:45Z

När och hur uppstår felet?

Permalänk: https://www.webforum.nu/p/2028777

## #3 — Travoni, 2007-09-17T13:38Z

Om jag kör denna fråga "direkt" : 

```
SELECT count(*) FROM SecUploadValider WHERE suv_guid = '234-sdf-234324-dsdfsdf-3s3';
```

 Så verkar det funka, men med sp:n så funkar det inte.

```
CREATE PROCEDURE `suv_get`(guid varchar(40))
BEGIN
SELECT count(*) FROM SecUploadValider WHERE suv_guid = guid;
END;

CREATE TABLE `secuploadvalider` (
  `suv_id` int(11) NOT NULL auto_increment,
  `suv_guid` varchar(40)  NOT NULL,
  `suv_datetime` datetime NOT NULL,
  PRIMARY KEY  (`suv_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
```

Permalänk: https://www.webforum.nu/p/2029071

## #4 — Travoni, 2007-09-17T13:48Z

Detta funkar ju iofs: 

```
CREATE PROCEDURE `suv_get`(guid varchar(40))
BEGIN
SELECT count(*) FROM SecUploadValider WHERE suv_guid = guid
[B]COLLATE latin1_general_ci[/B];
END;
```

Men det känns lite löjligt att lägga till det om det inte måstes... :)

Permalänk: https://www.webforum.nu/p/2029076

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/164535-illegal-mix-of-collations