insert farsi into tables
-
hi, i am using sql 2000 and i want to insert farsi into my table using a form which i wrote with c# but the problem is that they would inserted into it but when i want to show them they apeare as '???' where is my problem please?
hi can u give some sample code for this.... Regards Joe
-
hi, i am using sql 2000 and i want to insert farsi into my table using a form which i wrote with c# but the problem is that they would inserted into it but when i want to show them they apeare as '???' where is my problem please?
If you want to insert unicode text into text fields you need to make sure your fields are nvarchar, instead of varchar.
Mark Churchill Director Dunn & Churchill
-
hi can u give some sample code for this.... Regards Joe
thanks for answering me actually I found out how to do that in msdn the command which enables you to insert farsi(or any right to left languages) is: INSERT INTO tablename(columnnames) VALUES(N'' ,) like : INSERT INTO Employees(FirstName, LastName) VALUES(N'شاهين',N'معصومي') and the data type must be nvarchar thanx