March 3, 2009 at 3:08 am
How to insert arabic data into 2005 sql server
March 3, 2009 at 6:06 am
You need to be sure that your string data is defined as unicode so that you can define the character set as well as the values. This means NVARCHAR and NCHAR instead of VARCHAR & CHAR.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 4, 2009 at 9:23 pm
datatype of that field is nvarachar(2000).
when I insert the arabic text it is coming like this ??????????
can you help me
March 5, 2009 at 1:01 pm
Can you post a sample SQL call you use to store your data.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 5, 2009 at 1:10 pm
Grant Fritchey (3/3/2009)
You need to be sure that your string data is defined as unicode so that you can define the character set as well as the values. This means NVARCHAR and NCHAR instead of VARCHAR & CHAR.
Actually you can use ASCII characters and you don’t have to use Unicode. If you use code page 1256, then you can store Arabic letters in using ASCII instead of Unicode.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2009 at 1:13 pm
sajilsidharth (3/4/2009)
datatype of that field is nvarachar(2000).
when I insert the arabic text it is coming like this ??????????
can you help me
How are you trying to insert it? Are you doing it from an application or are you doing it from SSMS?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2009 at 1:39 pm
Actually you can use ASCII characters and you don’t have to use Unicode. If you use code page 1256, then you can store Arabic letters in using ASCII instead of Unicode.
I don't agree actually in SQL Server 2000 the code page needs to be added to the unicode definition as Grant said. When you use ASCII it becomes implementation dependent when you use unicode with the code page then most character conversion issues are resolved.
These are some of the reasons the right to left and the Asian languages are trying to break away from the 26 characters Latin alphabet controlled Unicode standard.
http://msdn.microsoft.com/en-us/library/ms144250.aspx
http://msdn.microsoft.com/en-us/library/ms143508.aspx
Kind regards,
Gift Peddie
March 5, 2009 at 7:51 pm
Sorry, I was away. Did Gift Peddie's post help because I was going to suggest the code page or possibly the collation next.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply