473,394 Members | 1,749 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

why MSSQL SERVER return question marks, when I execute query in PHP?

mikheil09
My Databese server is MSSQL SERVER and I connect to it with PHP's PDO class, connection is successful but when I execute query I receive question marks for all text type fields.

I have "UTF-8" in HTML Charset, My database collation is "Latin1_General_BIN" and fields type is nvarchar(50).

If you have some solition for this problem, please reply.
Oct 4 '11 #1
3 2242
omerbutt
638 512MB
have you tried using sql_srv extention for mssql in php i used it and didnt had any problems reading any field type in mssql 2010
Oct 4 '11 #2
Thank OMERBUTT you are right. I'm very happy....
Oct 4 '11 #3
omerbutt
638 512MB
my pleasure mikheil09 :) , glad to help please do choose the post as the best answer whenever you find the right solution from any of the users :) , it would help any other user who is having the same problem.
regards,
Omer Aslam
Oct 5 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Lenny Palozzi | last post by:
I'm looking for a way, via C/C++ code, to find the hostname and/or ip address of the MSSQL database server. I'm using the ODBC interface which, given a DSN and user/password allows me to connect...
1
by: Water Cooler v2 | last post by:
I am not able to start the MSSQL Server service on my system ever since I shifted my house and got a new network provider. Earlier, I was on the local cable hub, now my computer is on a DSL...
1
by: Anabella | last post by:
Hi all, is there any tool which is capable to convert query initially written for msaccess database to query for mssql server. I have tons of queries which contains iif, trim and similar...
0
by: SonGoten13 | last post by:
Hi The situation is that i should check on my intranet-page the rights of the user to decide wich information he can access. I have to use the Windows Login Information(User/pw). I found out that...
14
by: Kukurydz | last post by:
I've got such problem: My database is stored on MSSQL Server. I have to write reports for it in MSAccess. I've got a problem with creating a query which will select records from MSSQL table with...
4
by: Nanda | last post by:
hi, how to create database in mssql server using c#. We can create msacess database using adox, similiarly how to create sql server database using c#. Regards, Nanda.
5
by: alingsjtu | last post by:
Hello, every body. When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected...
1
by: karoto | last post by:
Dear sirs Recently i was make a Web Site writen in asp workspace. I use this string to my web.config file to connect to my mssql 2000 server. <add key="ConnStringSQL" value="Network...
1
by: CAG | last post by:
Hi, In my application, i'm storing sql query as value of table field in database. Like in my NewHireEmployee table, value of JoinDateQuery field can be (select hiredate from employeeInfo) or...
0
by: ruchika mahajan | last post by:
Hi all...MSSQL serevr 2000 Trace Event Column ObjectType gives value 17 for object table for events Object:Created and Object:deleted.Can anyone tell me all the possible values for MSSQL 2000 Trace...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.