Re: MySQL selects it's clients carefully?

This one was solved by an accident. Linux version of MySQL seems to be case sensitive what it comes to table names and Windows version is not. SQL standard prefers the case insensitive way. Lasse ""Lasse Laurila"" <lasse@laurila.net> wrote in message news:9885sf$99u$1@toye.p.sourceforge.net... > Environment: Two servers, which another has Windows 2000 Server and another > one runs Linux. Both of them has PHP (IIS/Apache) and MySQL installed. They > seemingly share configuration and they have exactly the same database > structure, data and PHP scripts as well. > > This combination works in following cases: > > - Linux PHP application uses Windows's MySQL database > > - Windows PHP application uses Windows's MySQL database > > - Linux MySQL client software uses Windows's MySQL database > > - Windows MySQL client software uses Linux's MySQL database > > - Either computer's MySQL client software uses MySQL database on the same > computer > > However, if PHP application on either server tries to use MySQL database on > the Linux server, it doesn't work. Symptom is quite strange: MySQL > connection is established normally, but any simple query fails to run (there > is no error, but it returns no result set). > > I've run all the tests on same user account and this situation is the only > one that fails. MySQL version is 3.23.33 and PHP version 4.0.4pl1. Any > ideas? > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >