Description:
When using MySQLCC for windows, and using a 4.1-alpha server for linux; when I use a GROUP_CONCAT together with a string comparisson function, such as "when address.name LIKE "%Jaime%" " I get gibberish in the CONCAT column. This fenomenon DOES NOT OCCUR in the command line.
How to repeat:
Here is a sample query:
SELECT
MATERIAS.NOMBRE,
SALONES.GRUPO,
SALONES.SALON,
GROUP_CONCAT(SALONES.DIA_SEMANA) AS DIAS,
CONCAT(SALONES.HORA_ENT,"-",SALONES.HORA_SAL) AS HORAS
FROM SALONES JOIN MATERIAS,DATOS_MAESTROS,HORARIOS,DATOS_ALUMNOS
ON
SALONES.ID_SALON=HORARIOS.ID_SALON AND
SALONES.ID_MATERIA=MATERIAS.ID_MATERIA AND
SALONES.ID_MAESTRO=DATOS_MAESTROS.MID
WHERE DATOS_MAESTROS.APELLIDO_PAT="Almeida"
GROUP BY SALONES.HORA_ENT
The "dias" column returns:
V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#
V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#
V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#
V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#
V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#
Suggested fix:
It must be some string manipulation thig in MySQLCC OR MAYBE the GROUP_CONCAT function.