C# 에서 mysql 저장프로시저 호출시 에러 발생
C# 에서 mysql 저장프로시저 호출시 에러 발생 base {System.SystemException} = {“Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’”}
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
CREATE DEFINER=`testCore`@`%` PROCEDURE `GetLog`(In sReq_SearchWord varchar(200)) BEGIN SELECT TraceId ,Req_SearchWord ,Req_File ,Response_File ,Regi_Date FROM BasicCode.FareLog where Req_SearchWord = sReq_SearchWord; END |
추가 : COLLATE utf8_unicode_ci
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
CREATE DEFINER=`testCore`@`%` PROCEDURE `GetLog`(In sReq_SearchWord varchar(200)) BEGIN SELECT TraceId ,Req_SearchWord ,Req_File ,Response_File ,Regi_Date FROM BasicCode.FareLog where Req_SearchWord = sReq_SearchWord COLLATE utf8_unicode_ci; END |