Hi Ralf,
Thanks for the advice !
I have tried to enter manually the sql query generate and send by
sqlfs_stream_wrapper.inc.php line 1020:
if (!($result = self::$pdo->query($query)) || !($info = $result->fetch(PDO::FETCH_ASSOC)))
and here is the result:
SELECT fs_id, fs_name, fs_mode, fs_uid, fs_gid, fs_size, fs_mime, fs_created, fs_modified,
CASE fs_mime
WHEN 'application/x-symlink’
THEN fs_content
ELSE NULL
END AS readlink
FROM egw_sqlfs
WHERE fs_name
COLLATE utf8_bin = 'test’
AND fs_dir = (
SELECT fs_id
FROM egw_sqlfs
WHERE fs_dir = ( 1 )
AND fs_name
COLLATE utf8_bin = 'home’
AND (
fs_mode &04
OR fs_mode &0400
AND fs_uid =6
OR fs_mode &040
AND fs_gid
IN ( 195, 1, 2, 3, 8, 248, 197 ) )
)
LIMIT 0 , 30
MySQL answered:Documentation
#1253 - COLLATION ‘utf8_bin’ is not valid for CHARACTER SET ‘latin1’
so if I change
self::$case_sensitive_equal = ’ COLLATE utf8_bin =’;
into
self::$case_sensitive_equal = ’ COLLATE latin1_swedish_ci =’;
the problem disappears (by i guess i loose case sentivity…)
so the problem is that my database is in latin1_swedich_ci and not in utf8…
does it mean everyone should change database to utf8 ???
in this case, it would be good to test this in setup process…
thank you so much for all this work
