July 27, 2009 at 4:39 am
Dear Brother's
I there any way tostore information in SQL Server2005 other then english Language like hindi, Urdu etc. Please i there any way then please share me..
Thanks
Best regards
Waqar Hussain Laghari
July 27, 2009 at 5:15 am
SQL server can store most languages, if you want to store languages that do not use the latin characters then you will need to use uni code columns to store the data, eg. Nvarcahr Nchar etc.
You will also need to use the unicode leading 'N' when inserting data into these columns.
http://msdn.microsoft.com/en-us/library/bb330962(SQL.90).aspx
July 29, 2009 at 1:31 am
Dear brother can you give me some example that stored infomration of unicode in in the database table.
Best regards
Waqar Hussain Laghari
July 29, 2009 at 10:41 am
waqarlaghari (7/29/2009)
Dear brother can you give me some example that stored infomration of unicode in in the database table.
Just try it with any SQL NVARCHAR() column or variable. It is far easier for you to try this than it is for us to find and identify a valid example of Urdu text somewhere.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 14, 2009 at 10:40 am
If I remember right Urdu is a right to left langauge like Arabic so read the article in the link below and add Urdu in the configurations instead of Arabic and post again if you still need help with what is the problem. You can do the same with Hindi but I don't think it is a right to left language. The reason you can use Urdu and Hindi as collations if you use Windows collations instead of SQL Server. One more thing your SQL Server 2005 should be at least SP2.
http://msdn.microsoft.com/en-us/library/cc295829(SQL.90).aspx
Kind regards,
Gift Peddie
August 14, 2009 at 10:55 am
Heh. OK, it's far harder for *most* of us to find and validate working Urdu. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 14, 2009 at 11:09 am
Urdu is in the Windows collation table under Pakistan but since the user asked for both Hindi and Urdu that may be the part of India that uses both languages so I was providing how both right to left Urdu and none right to left Hindi can use the same database.
http://msdn.microsoft.com/en-us/library/ms143508.aspx
Kind regards,
Gift Peddie
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply