question

zoormoor avatar image
zoormoor asked

[SQL Server 2005 Express] Arabic / Urdu Texts Not Properly Save / Display

Unable to Display Arabic / Urdu Text properly in nvarchar column of SQL Server 2005 With Column Collation SQL_Latin1_General_CP1256_CI_AS and Arabic_CI_AI respectively but no luck... For your information if I put complete word کتاب than SQL Server breakup whole word and displays ک ت ا ب in column... Please Guide...
unicode
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Ive never had a requirement to store URDU/ARABIC into SQL Server. Though I'd be interested in the answer too.
0 Likes 0 ·
I have stored Arabic in the same tables as russian, english, greek and some 20 more languages, and I have read the different languages in the same query, and displayed them on the same webpage. These texts are collected from a website, and displayed in the same website. The trick in that case is using correct codepage settings both in the @-directive in the website, and the correct codepage in the META HTML tag. Oh - and also to NOT put any "special" characters in clear text in the HTML-part of the aspx-, or asp-sourcefile, they should be HTML-escaped, otherwise the displaying of non US ASCii characters get messed up. Column collation hasn't been changed from the time when we stored only english in the table.
0 Likes 0 ·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
How are you inserting the text? How are you viewing the text? Are you inserting directly from Management Studio? Are you using an INSERT query in SSMS? Are you inserting from an application? Are you viewing the data in the table in SSMS? Are you viewing in a query-results window? Are you viewing the data in an application?
5 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

If I read the question correctly (which I doubt), it sounds like @zoormoor is trying to view the Urdu text within SQL server itself - I guess with SSMS, which has been known to be full of FAIL when dealing with more "interesting" character sets...
2 Likes 2 ·
There are other areas of SQL Server programming where thare are even more pitfalls :)
1 Like 1 ·
It could very well be as easy as you suggest in your answer - the font doesn't support the language. But there are a few pitfalls to avoid when dealing with unicode.
0 Likes 0 ·
only a few? ;-)
0 Likes 0 ·
I am Inserting / Viewing Data Directly in SSMS and also checked the output in Query Result Window both generate same result.
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
Do all the fonts you are using have the appropriate characters set up in them? With the right kerning rules?
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

The font is full compatible with unicode character set of arabic / urdu language.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.