From: Ralf B. <rb...@st...> - 2009-03-31 11:53:36
|
Hi, new installations no longer allow to setup anything but utf-8. It was not documented as a requirement in 1.6, but we are not talking about 1.6, but trunk. I think with the next release we will force everyone to update to utf-8. You either switch now to utf-8, which I strongly recommend, as it is the only supported charset in eGW. Or you fix the code by replacing utf8_bin with latin1_bin. The update is easy to do, but you will loose all preferences and configurations, which contain non-ascii (8-bit) chars! Ralf skyfredox schrieb: > 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 > ------------------------------------------------------------------------ > View this message in context: Re: Debuging FileManager > <http://www.nabble.com/Debuging-FileManager-tp22777869s3741p22802932.html> > Sent from the egroupware-developers mailing list archive > <http://www.nabble.com/egroupware-developers-f3744.html> at Nabble.com. > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > > > ------------------------------------------------------------------------ > > _______________________________________________ > eGroupWare-developers mailing list > eGr...@li... > https://lists.sourceforge.net/lists/listinfo/egroupware-developers -- Ralf Becker Director Software Development Stylite GmbH [open style of IT] Morschheimer Strasse 15 67292 Kirchheimbolanden fon +49 (0) 6352 70629-0 fax +49 (0) 6352 70629-30 mailto: rb...@st... www.stylite.de www.egroupware.org ________________________________________________ Geschäftsführer Andre Keller, Nigel John Vickers, Gudrun K. Müller und Ralf Becker Registergericht Kaiserslautern HRB 12087 |