I don't know the reason (perhaps OS-based, since tables are implemented as
eponymous files), but it was a pretty awful idea to allow special chars in
names in the first place.
you probably have only two options, equally unpleasant:
- rename your tables and columns
- back-tick all your non-standard names in queries:
`négociateurs`.`téléphone`... (not even sure it will work, and don't want to
(BTW there is a similar problem with your e-mail name!! "EKSTEIN, Clément @
Paris" translates as "EKSTEIN; Clément @ Paris" in the "To" with Outlook
Express, causing a failure to answer...)
Stick to standards.
----- Original Message -----
From: "EKSTEIN, Clément @ Paris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 06, 2003 11:46 AM
Subject: [PHP-DB] mssql and Apache 1.3.28 and Win2k
> I'm not shure that's a pure PHP bug, the problem only occur since
> I've ugraded Apache to 1.3.28.
> All SQL queries containing tables or column names containing special chars
> e) fails with the following PHP error message : "mssql_query(): message:
> Invalid object name 'Negociateurs'. (severity 16)".
> I've tested few PHP 4.3.X versions with previous Apache releases and it
> so I think the problem is comming from the 1.3.28 version and PHP module.
> I'm runing Win2k SP4, MSSQL 2K.
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php