witam mam problem z zapytaniem:

[SQL] pobierz, plaintext 
  1. SELECT quest.id, quest.full_name, quest.poster_id, quest.added, user.id AS user_id, user.nick FROM tdg_quests quest, tdg_users user WHERE LEFT(full_name,1) BETWEEN '0' AND '9'
[SQL] pobierz, plaintext


ktore zwraca nastepujacy blad:

Kod
Problem z query:
SELECT quest.id, quest.full_name, quest.poster_id, quest.added, user.id AS user_id, user.nick from tdg_quests quest, tdg_users user WHERE LEFT(full_name,1) BETWEEN '0' AND '9'
Illegal mix of collations (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'between'