쿼리에서 에러가 났습니다. |
쿼리문 |
select count(*) from `R_life_mamul` as a, `R_life_expiry` as b where a.no=b.pno and a.`code`='sell' 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 '%綺煞濚�%' or a.`content` like '%綺煞濚�%' ) and a.trade='sell' and (b.`premium`>='2025-05-19' or b.`premium`='1111-11-11') and a.open='yes' |
|
에러메세지 |
ERROR CODE 1267 : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation \'like\' |
|
페이지 |
/display/list.html |
|
| |