ID: 30119 User updated by: dehrmann at free dot fr Reported By: dehrmann at free dot fr Status: Bogus Bug Type: MSSQL related Operating System: XP -PHP Version: 4.3.7 +PHP Version: 4.3.3 New Comment:
I know that. I use [] and it still not working. The problem reside in the conjonction of php, php_mssql.dll ntwdlib.dll and the client utility for mssql server (sql server enterprise manager). I say that the same program is OK on a station under XP but whitout 'sql server enterprise manager'. I do the following : i copy the entire config of easyphp from the pc where it work to the another. We can say that the config is the same. It is still not working fine. I think that the problem is sharing the system with the manager for msql server. This is the only difference between the 2 station's. Previous Comments: ------------------------------------------------------------------------ [2004-09-16 23:11:31] [EMAIL PROTECTED] This is not a problem with PHP. You should escape field names with special characters. MSSQL Server does this by including each field name in [], like this: select [�tat] from [my table] ------------------------------------------------------------------------ [2004-09-16 16:54:59] dehrmann at free dot fr Description: ------------ I have a pc with easy php installed, MSDE (sql server local) and sql server enterprise manager. I have no problem to connect to my database on another server (2k). But when i query the database with fields with accent (like �tat), i have a bug saying that the name of the column ar not correct. I use the same program on antoher pc that don't have the sql server enteprise manager on it, the same code will work fine !!!! If you have sql server enteprise manager installed on your web server you have the same pb. I took the NTWDLIB.DLL in all parts of my pc, the bug is the same. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30119&edit=1
