473,416 Members | 1,571 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,416 software developers and data experts.

encoding problem with MSSQL and php

Dear sir,
i am tring to use mssql with php for my web application.
But i am facing problme with arabic chararcters.
it appears like as ������������.
can anyone tell me how to fix this error?


Regards,
Faruk Chowdhury.

Expand|Select|Wrap|Line Numbers
  1. //Query to connect MSSQL
  2.  
  3. $myServer = 'localhost';
  4. $myUser = 'sa';
  5. $myPass='';
  6. $myDB='pos';
  7.  
  8.  
  9. $dbhandle = mssql_connect($myServer,$myUser,$myPass) or die('Error connecting to mssql');
  10.  
  11.  
  12. $selected = mssql_select_db($myDB,$dbhandle)or die('Error connecting to mssql');
  13.  
  14. // Query to retrive informations..
  15.  
  16. $result1 = mssql_query("select  first_name , family_name ,father_name ,grand_father_name  ,city ,zip_code ,p_o_box ,mobile_no  from client_info where id_no = '$id_no' ");
  17.  
  18.  
  19.  
Sep 23 '10 #1
1 2475
ck9663
2,878 Expert 2GB
I have not tried doing that before. Maybe this would help...

Good Luck!!!

~~ CK
Sep 23 '10 #2

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

Similar topics

3
by: Guillaume | last post by:
Hello, I have a strange problem while using mssql server driver: when i update/insert in/delete a table and want to redirect after, i have the following error message: CGI Error The specified...
9
by: Darren | last post by:
Hi wondering if anyone can help. What i'm trying to do is get a company from a MSSQL database with the COMPANYNO which is a 'uniqueidentifier'. Then with this COMPANYNO I want to reference it to...
7
by: jonathan.kleid | last post by:
I'm trying to figure out how to enable chunked encoding with php over apache2 for a particular page. My php/apache combination definitely supports chunked encoding, because a page which calls only...
0
by: Janusz Nykiel | last post by:
I've stumbled upon unexpected behavior of the .NET 2.0 System.Xml.XmlWriter class when using it to write data to a binary stream (System.IO.Stream). If the amount of data is less than a certain...
3
by: Robert Johnson | last post by:
Hi all. My datasource is a MSSQL 2005 database with several tables all visable in my datasources tab. I can preview data in the Designer OK so my connection is fine. Now, I add a form, drag from...
0
by: exclaim | last post by:
Apologies if this is not the right forum. I have an application written originally to work with MySQL which now has to be extended to work with MSSQL also. I have modified all my database calls...
1
by: kkzin | last post by:
Hi, there I created C# automation excel add-in named "MyExcelAddin" like that link. http://msdn.microsoft.com/en-us/library/ms173189(VS.80).aspx "MyExcelAddin.MyClass1" contains one function: ...
10
by: khalid galal | last post by:
Hi, i am having a problem with connecting ASP with MSSQL SEVER 2005 EXPRESS EDITION, i am writing ASP code using javascript. look at this peace of code: var myConnect = "Provider=SQLNCLI;Data...
0
by: anjali123 | last post by:
Hi, I want to prepare crystal reports for my project. I am using the database that is inbuilt with the visual studio (MSSql Database file). I didnt know what to choose as datasource to create a...
1
by: coolminded | last post by:
hello all, i'm getting problem while connecting another mssql server. but i can connect with localhost. my connection string that runs is con.Open "Provider=SQLOLEDB.1;Integrated...
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.