Localization in SQL Server- is there such a thing? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Localization in SQL Server- is there such a thing?

Author

Topic

Mourad
Starting Member

6 Posts

Posted - 2007-04-30 : 17:00:21

Hello all,
I'm working on an ASP.NET with a SQL server for database. Some of the tables, for example, contain information such as different types of Fabrics (silk, cotton, etc..) . I'd like to have this table localizable (English and French for instance). Is this possible ? Is there an equivalent of resource files in SQL server ?
Or do I have to do this manually ? (have 2 separate fields in the table for those 2 locales)

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2007-04-30 : 19:23:59

I'm not aware of any built in localization handling like that in SQL Server.

I would suggest that you not just add a field to your table to hold the other value, but instead create a another table and link it to your existing table and include a CodePage/LocalID/CulterID (whatever you want to use) so that you can support any number of locals.

For a rough example, something like:

CREATE TABLE Fabric(ID INT, Description VARCHAR(255), FabricNameDefault NVARCHAR(255))
CREATE TABLE FabricLocal(ID INT, CodePage INT, FabricNameLocal NVARCHAR(255))

With FabricLocal.ID being a foreign key to Fabric.ID.

EDIT: Here is a link of a possible way to Localize text for your web app:[url]http://devpinoy.org/blogs/dehranph/archive/2006/11/08/l10n-localization-on-database.aspx[/url]

-Ryan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources