September 3, 2005 at 11:18 am
Hi,
I am fairly new to SQL Server and I am involved in a project to create a database which needs to support English, Spanish and the Slovene language.
I have been reading about globalization and collations but I am still not sure as to the way to proceed. I would really appreciate some help.
1) What collation to use for creating the DB so that it supports all three languages?
2) There will be a VB.NET client accessing the DB. What do I need to bear in mind to access the database. I've looked at the .NET internationalization. is this the best way to go?
3) There will be an ASP.NET website which needs to work also in the three languages. What is the best way to proceed.
Many thanks in advance for any help that you can give me.
Thanks
JM
September 3, 2005 at 10:55 pm
Try the links below for all you need to do localization in Asp.net and SQL Server including Unicode encoding your tables and in Visual Studio 2003. You can do column level collation in SQL Server 2000 and use NVarchar, NChar and NText the former are 4000 while the later is 1gig. In the second link I have posted links for the .NET localization tool kit and some sample code for application level localization. Hope this helps
http://www.aspnetresources.com/blog/unicode_in_vsnet.aspx
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=230&messageid=205432
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply