|
|
Query: select c.userid,c.nev,count(distinct k.kategid)kategek,count(distinct g.id)kepek from AMIGAMAIN.cimek c,AMIGAPICS.pics p,AMIGAPICS.kateg k,AMIGAPICS.kategek g where c.userid=p.bevitid and c.userid=k.tulaj and k.kategid=g.kategid and g.id=p.id and k.tipus='P'and c.nev regexp"^[���������\!\@\#\$\%\^\&\*\(\)\/\~\.\,\;\:\|\=\+\'\`���������\!\@\#\$\%\^\&\*\(\)\/\~\.\,\;\:\|\=\+\'\`]+"group by c.userid order by c.nev*1,c.nev asc
Error message: Illegal mix of collations (latin2_hungarian_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'regexp'
File: /Main.php