|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2000-11-06 03:36 UTC] walidm at sport-away dot com
I'm french and I'm working on an already created MSSQL DB. The problem is that some columns are "in french" which means that they contains an accent in their name and it seems that the MSSQL70 module from PHP 4.03 does not know how to deal with it. Here is an example : I have a table which contains a column called "march?". With the query analyser from MSSQL70, my query is working perfectly but when I use the same query with PHP, it doesn't work and says that the column "march?" doesn't exist ... If I try with any other column (without the accent), it works flawlessly so it s not a problem from my query ... I can't change the name of the column, there is too much work relying on it so please, help me ... Thanks. PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Fri Apr 19 05:01:29 2024 UTC |
Testing this on windows 2000 gives the expected result. This code: $con = mssql_connect($db, $user, $password); $rs = mssql_query("select * from phptest", $con); while ($data = mssql_fetch_array($rs)) { print($data["march?"] . "\n"); while (list($col, $dat) = each($data)) print($col . "=" . "\n"); } print("\n"); mssql_free_result($rs); mssql_close($con); Works when uses from the web server. If you use the same code from the command line you need to enter ? in the correct code page.