| 쿼리에서 에러가 났습니다. |
| 쿼리문 |
select b.*, a.* from R_life_mamul a, R_life_expiry b where a.`no`=b.`pno` and a.`code`='sell' and a.`open`='yes' and ( a.`build_name` like '%占쏙옙키占쏙옙占쏙옙煞占쏙옙占�%' or a.`form_txt` like '%占쏙옙키占쏙옙占쏙옙煞占쏙옙占�%' or a.`pno_text` like '%占쏙옙키占쏙옙占쏙옙煞占쏙옙占�%' or a.`mutual` like '%占쏙옙키占쏙옙占쏙옙煞占쏙옙占�%' or a.`tel` like '%占쏙옙키占쏙옙占쏙옙煞占쏙옙占�%' or a.`goods` like '%占쏙옙키占쏙옙占쏙옙煞占쏙옙占�%' or a.`job` like '%占쏙옙키占쏙옙占쏙옙煞占쏙옙占�%' or a.`address` like '%占쏙옙키占쏙옙占쏙옙煞占쏙옙占�%' or a.`add_content` like '%占쏙옙키占쏙옙占쏙옙煞占쏙옙占�%' ) and (b.`line`>=curdate() or b.`preferential`>=curdate() or b.`premium`>=curdate() or b.`premium`='1111-11-11' or b.`preferential`='1111-11-11' or b.line='1111-11-11') limit 5 |
|
| 에러메세지 |
ERROR CODE 1267 : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation \'like\' |
|
| 페이지 |
/display/search_all.html |
|
| |
