Äõ¸®¿¡¼ ¿¡·¯°¡ ³µ½À´Ï´Ù. |
Äõ¸®¹® |
select count(*) from `R_life_mamul` as a, `R_life_expiry` as b where a.no=b.pno and a.`code`='servies' 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 (b.`premium`>='2024-04-26' 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 |
|
| |