I need help with SQL snack? I need help SNACK ARABIC
I have a table dbo.Quran.Quran with the following columns:
QuranID varchar (10) NOT NULL,
ChapterID varchar (10) NOT NULL,
VerseIdBegin varchar (10) NOT NULL,
VerseIdEnd varchar (10) NOT NULL,
AyahText varchar (8000) NOT NULL
when I go:
INSERT INTO Quran (QuranID, ChapterID, VerseIdBegin, VerseIdEnd, AyahText) VALUES (1,1,1,1, N 'بسم Øsلله ØsلرØمن ØsلرØيم)
the row is added successfully, but
when I access it through a SELECT statement:
Select * from Quran where ChapterID VerseIdBegin = 1 and = 1
AyahText last column displays question marks instead of "بسم Øsلله ØsلرØمن ØsلرØيم
I posted the issue of MSDN, and followed the resolution of problems like this:
I know that the problem is related to the encoding, I changed the classification dB SQL_Latin1_General_CP1256_CI_AS and collation of the column of the Arabic language in Windows
but the same thing ...
Has worked with her before??? Anyone know the SOLUTION
PLZ Let Me Know
Use
AyahText nvarchar (4000) NOT NULL
Otherwise, you also need to work on:
1) lang = "ar"> xmlns = "http://www.w3.org/1999/xhtml" <html
2) <meta http-equiv="Content-Type" content="text/html; charset=windows-1256" />
3) <meta name="language" content="ar" />
4) Also look at http://en.wikipedia.org/wiki/Code_page
Posted on July 13, 2010.
