Mysql - Error : Illegal mix of collations

Posted 02 13, 2013 14:15, Filed under: DataBase/Mysql


# 쿼리 실행시 아래와 같은 에러 메세지 발생


Lookup Error - MySQL Database Error: Illegal mix of collations (euckr_korean_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='


# 처리
 - 변경 대상이 되는 쪽의 조건 절에 collation 을 맞춰줌.
  COLLATE utf8_general_ci

  FROM NEWS N, VIEW_NEWS VN            
  WHERE N.BOARD_GROUP = VN.BORAD_GROUP COLLATE utf8_general_ci

※ 위 내용은, 여러 자료를 참고하거나 제가 주관적으로 정리한 것입니다.
   잘못된 정보나 보완이 필요한 부분을, 댓글 또는 메일로 보내주시면 많은 도움이 되겠습니다.
02 13, 2013 14:15 02 13, 2013 14:15


Trackback URL : http://develop.sunshiny.co.kr/trackback/855

  1. utility bill printing and mailing

    Tracked from utility bill printing and mailing 01 24, 2020 07:01 Delete

    Start utilizinging the best available print and mail services today and start making results today!

  2. important link

    Tracked from important link 01 25, 2020 14:21 Delete

    Start utilizinging the best available mail printing services immediately and start making results today!

  3. los cabos mexico villas

    Tracked from los cabos mexico villas 01 27, 2020 06:45 Delete

    Get the best los cabos beaches that are available plus at the best price today!

  4. short term rental property insurance

    Tracked from short term rental property insurance 01 28, 2020 03:15 Delete

    Get going today with the most professional airbnb host protection insurance that are currently available and at a great value today only!

Leave a comment

« Previous : 1 : ... 156 : 157 : 158 : 159 : 160 : 161 : 162 : 163 : 164 : ... 648 : Next »

Recent Posts

  1. HDFS - Python Encoding 오류 처리
  2. HP - Vertica ROS Container 관련 오류...
  3. HDFS - Hive 실행시 System Time 오류
  4. HP - Vertica 사용자 쿼리 이력 테이블...
  5. Client에서 HDFS 환경의 데이터 처리시...

Recent Comments

  1. Generally I do not read post on bl... 레기읏룸 셔츠룸 차이. 레깅스룸 부엉이 01 24,
  2. Wonderful site. A lot of useful in... /427 01 23,
  3. 안녕하세요^^ 배그핵
  4. 안녕하세요^^ 도움이 되셨다니, 저... sunshiny
  5. 정말 큰 도움이 되었습니다.. 감사합... 사랑은

Recent Trackbacks

  1. cabo packages cabo packages %M
  2. airbnb host insurance airbnb host insurance %M
  3. beaches in cabo beaches in cabo %M
  4. joe’s dj service joe’s dj service %M
  5. short term rental property insurance short term rental property insurance %M

Calendar

«   01 2020   »
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

Bookmarks

  1. 위키피디아
  2. MysqlKorea
  3. 오라클 클럽
  4. API - Java
  5. Apache Hadoop API
  6. Apache Software Foundation
  7. HDFS 생태계 솔루션
  8. DNSBL - Spam Database Lookup
  9. Ready System
  10. Solaris Freeware
  11. Linux-Site
  12. 윈디하나의 솔라나라

Site Stats

TOTAL 2824850 HIT
TODAY 469 HIT
YESTERDAY 443 HIT