#30119 [Opn->Bgs]: bug in query with mssql an enterprise manager installed

ID: 30119 Updated by: fmk@php.net Reported By: dehrmann at free dot fr -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: XP PHP Version: 4.3.7 New Comment: 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] Previous Comments: ------------------------------------------------------------------------ [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