MySQL Forums
Forum List  »  Turkish

Illegal mix of collations Problemi
Posted by: Atilla Ilhan KARTAL
Date: October 14, 2010 03:41AM

CREATE DEFINER = CURRENT_USER PROCEDURE `isRelation`(
IN TableName VARCHAR(100),
IN FieldName VARCHAR(100),
IN DatabaseName VARCHAR(100)
)
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
SELECT c.table_schema,u.table_name,u.column_name,u.referenced_column_name
FROM information_schema.table_constraints AS c
INNER JOIN information_schema.key_column_usage AS u
USING( constraint_schema, constraint_name )
WHERE c.constraint_type = 'FOREIGN KEY'
AND u.referenced_table_schema=DatabaseName
AND u.referenced_table_name=TableName
AND u.column_name=FieldName
ORDER BY c.table_schema,u.table_name;
END;

Arkadaşlar yukarıdaki sp ile parametrelerde belirtilen değerlerin ilişkilerini almak istiyorum. Lakin

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_turkish_ci,IMPLICIT) for operation '='

Hatası almaktayım bunun nedeni ve çözümü nedir?

Teşekkürler

Options: ReplyQuote


Subject
Views
Written By
Posted
Illegal mix of collations Problemi
4650
October 14, 2010 03:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.