Hello guys!
How can i fix this?
DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Illegal mix of collations (latin2_general_ci,COERCIBLE), (latin2_general_ci,COERCIBLE), (latin1_swedish_ci,IMPLICIT) for operation 'replace'
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# - Hello','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.look,ps.socket0,ps.socket1,ps.socket2,ps.socket3,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
Thank you for your time!