Probleme de caractères avec une procédure stockée

Version imprimable

Bonjour, lors de la création de ma procédure stockée, j'ai un message d'erreur:

Message d'erreur:

Code:

1
2
MySQL Error Number 1270
Illegal mix of collations (utl8_general_ci,COERCIBLE),(utl8_general_ci,COERCIBLE),(latin1_swedish_ci,IMPLICIT) for operation 'concat'

Code de ma procédure stockée:

Code:

1
2
3
4
5
6
7
8
9
10
CREATE VIEW vplan_creneau AS
SELECT crn_id    as vcrn_creneau,
       crn_date  as vcrn_date,
       crn_default as vcrn_default,
       dix_debut as vcrn_debut,
       dix_fin   as vcrn_fin,
       STR_TO_DATE(concat(DATE_FORMAT(crn_date,GET_FORMAT(DATE, 'ISO')),' ',dix_debut),concat(GET_FORMAT(DATE, 'ISO'),' %H:%i')) as vcrn_date_debut,
       STR_TO_DATE(concat(DATE_FORMAT(crn_date,GET_FORMAT(DATE, 'ISO')),' ',dix_fin),concat(GET_FORMAT(DATE, 'ISO'),' %H:%i')) as vcrn_date_fin
  FROM plan_dixieme,plan_creneau
 WHERE dix_id = crn_dixieme;

Merci pour vos réponses,

tu peux préciser la collation pour chaque champ de ton concat ;)

Code:

1
2
3
4
5
6
7
8
9
10
11
 
CREATE VIEW vplan_creneau AS
SELECT crn_id    AS vcrn_creneau,
       crn_date  AS vcrn_date,
       crn_default AS vcrn_default,
       dix_debut AS vcrn_debut,
       dix_fin   AS vcrn_fin,
       STR_TO_DATE(concat(DATE_FORMAT(crn_date,GET_FORMAT(DATE, 'ISO')),' ' COLLATE utf8_general_ci,dix_debut),concat(GET_FORMAT(DATE, 'ISO'),' %H:%i')) AS vcrn_date_debut,
       STR_TO_DATE(concat(DATE_FORMAT(crn_date,GET_FORMAT(DATE, 'ISO')),' ' COLLATE utf8_general_ci,dix_fin),concat(GET_FORMAT(DATE, 'ISO'),' %H:%i')) AS vcrn_date_fin
  FROM plan_dixieme,plan_creneau
 WHERE dix_id = crn_dixieme;

27/03/2008, 10h55
spaukensen

En fait merci ca marche du feu de dieu en précisant les collations