달력이 안떠요..
- 작성자 :
- 김*윤
- 작성일 :
- 2011-01-05 16:25:27
- 조회수 :
- 2,388
- 구분 :
- 공통컴포넌트
- 진행상태 :
- 완료
Q
데이터 처리 중 오류가 발생하였습니다.
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1267];
--- The error occurred in egovframework/sqlmap/com/cmm/sym/cal/EgovRestdeManage_SQL_Mysql.xml.
--- The error occurred while applying a parameter map.
--- Check the RestdeManageDAO.selectNormalRestdePopup-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (euckr_korean_ci,IMPLICIT) for operation '='; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/com/cmm/sym/cal/EgovRestdeManage_SQL_Mysql.xml.
--- The error occurred while applying a parameter map.
--- Check the RestdeManageDAO.selectNormalRestdePopup-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (euckr_korean_ci,IMPLICIT) for operation '='
mysql쓰는데 쿼리문이 잘못되서 그런건가요? 디비 기본 인코딩 utf8입니다.
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1267];
--- The error occurred in egovframework/sqlmap/com/cmm/sym/cal/EgovRestdeManage_SQL_Mysql.xml.
--- The error occurred while applying a parameter map.
--- Check the RestdeManageDAO.selectNormalRestdePopup-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (euckr_korean_ci,IMPLICIT) for operation '='; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/com/cmm/sym/cal/EgovRestdeManage_SQL_Mysql.xml.
--- The error occurred while applying a parameter map.
--- Check the RestdeManageDAO.selectNormalRestdePopup-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (euckr_korean_ci,IMPLICIT) for operation '='
mysql쓰는데 쿼리문이 잘못되서 그런건가요? 디비 기본 인코딩 utf8입니다.
A
안녕하세요.. 김태윤님..
DB의 해당 table char. encoding이 입력하신 값의 encoding이 맞지 않아서..
발생된 문제입니다.
테이블을 다시 생성하시거나.. 입력값을 변환하시면 될 것 같습니다.
그럼.. 즐거운 하루되십시오.
감사합니다.
DB의 해당 table char. encoding이 입력하신 값의 encoding이 맞지 않아서..
발생된 문제입니다.
테이블을 다시 생성하시거나.. 입력값을 변환하시면 될 것 같습니다.
그럼.. 즐거운 하루되십시오.
감사합니다.