Schema localization

I am trying to find out the best way to localize my Schema.
the problem is that i have many table with allot of columns that need to be 
locolized to un known number off languages.

does any knows off a good artical or "best practice" for locolization  


Rani W

12/30/2009 8:57:01 AM
sqlserver.programming 1873 articles. 0 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 19

What do you mean by 'localize schema'?

"RaniW" <> wrote in message
> Hi,
> I am trying to find out the best way to localize my Schema.
> the problem is that i have many table with allot of columns that need to 
> be
> locolized to un known number off languages.
> does any knows off a good artical or "best practice" for locolization
> -- 
> Thank''''s
> Rani W

12/30/2009 9:28:39 AM
RaniW ( writes:
> I am trying to find out the best way to localize my Schema. the problem
> is that i have many table with allot of columns that need to be 
> locolized to un known number off languages. 
> does any knows off a good artical or "best practice" for locolization  
The way we do it in our system is that we have specific name tables.

Say that you have a Products table with a ProductName column. To that we
would add ProductNames with the columns ProductID, LangaugeID and 
ProductName, of which the first would be the key.

The languages are defines in the Languages table, and the ID are taken
from Windows, using the major id only, so English is 9, Swedish is 29 and
so on.

Queries then goes:

   SELECT ... ProductName = coalesce(PN.ProductName, P.ProductName) ...
   FROM   Products P
   LEFT   JOIN ProductNames PN ON PN.ProductID = P.ProductID
                              AND PN.Language = @current_language

That is, there is still is a name column in the main table, and this
column duplicates the name in the main language of the system. In this
way we can ascertain that we always return a name, even if there is none
defined in the current language.

There are a few situations where this is slightly more complicated, and
we have a three-step search for the name. In most cases the language is
determined by the current user, but we also produce reports that are sent
to end customers. In this case, we use the language on the address. In
this case, the preference order is:

1) The customer's language.
2) The default language for customers (i.e. English)
3) The system language (often Swedish or Finnish)

In the end what matters are your business requirements, but this outline
might give you some ideas.

Erland Sommarskog, SQL Server MVP,

Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
12/30/2009 9:39:16 AM

Similar Artilces:

The application-specific permission settings do not grant Local Ac
I have crm 3.0 and sql 2005 on separate servers. When I select Reports in My Activities, appears: Error. Please contacte the system administrator. The SQL 2005 is 64 bits on Windows 2003 64 bits. -- Allan Machado Microsoft Certified Professional Hi Alan, Are you accessing your CRM using an IP address or name, if it's IP address, it will not work. It only works with name because IP don't work with Kerbero. If it's still not working, follow the white paper from Microsoft to check your SPN, etc... Hope this will help. Darren Liu Crowe Chizek and Company http://www.crowecrm....

eConnect Schema
Can someone point me to the correct Schema/XML node to enter data to the Transaction Entry screen found in the path Transactions, Financial, Batches, Transaction button ? I believe that would be <taGLTransactionLineInsert>.... -- Bud Cool Microsoft Certified Business Management Solutions Specialist, GP 9.0 Financials Currently supporting: GP 9.0, SP2 "DavidM" wrote: > Can someone point me to the correct Schema/XML node to enter data to the > Transaction Entry screen found in the path Transactions, Financial, Batches, > Transaction button ? > > > ...

Project table schema changes in 9.0
I upgraded a server from GP 8.0 sp5 to GP 9.0 sp2 last weekend. All seems to work fine so far. I have some Crystal Reports that were in the process of being developed and I have questions about 3 Project tables. These tables each have had fields removed. My question is...Where has the data these fields represented been relocated? Has the upgrade taken data from these tables and moved it to other tables? PA10721 -> PA31101 -> PA31102 -> *** Lists the fields added and removed in Project tables *** C:\Program Files\Microsoft Dynamics\GP 9.0 SDK\Content\8.0to9.0\PaTableDetailed_...

xsd.exe errors with schemas importing other schemas
Hi, I am working with XSD.exe command line util. I have an XSD that I am trying to use to generate classes with. However, the XSD references another schema and the XSD.exe is having trouble finding the referenced schema. Does anyone have an example of what the command line params would be so that the tool is aware of all schemas? Does the tool have trouble with the XSD lines: xmlns:r="somewhere.files.referencedxsd" <xs:import schemaLocation=".\referencedxsd.xsd" namespace="somewhere.files.referencedxsd" /> <xs:element ref="r:ReferencedRo...

xml schema: elements with unique attribute values.
Hi all. I�m a bit newbie writing xml schemas. Is it possible to define xml element that must have unique attribute values in same level. For example if i have a xml - document: <list> <subsection name="first"> <!-- subsection contents --> </subsection> <subsection name="first"> <!-- ERRROR!!! --> <!-- subsection contents --> </subsection> <subsection name="second"> <!-- subsection contents --> </subsection> </list> Schema: <xs:complexType n...

Integration Manager Local Translation copied to Global Translation
We would like the ability to copy a Local Translation table to a Global Translation table in Integration Manager ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.

How to view a complete schema when using schema includes/imports?
I've got a parent schema file that references complex element types that are defined in several "child" schema files and I used the schema imports statement to include them into the parent schema's default namespace. I would like to generate a complete/single-file instance of the schema to simplify things but I can't figure out how to do it. Each schema seems to live in it's respective memory space inside the SchemaIncludesCollection. Any idea how I could traverse all of the "virtual" nodes in the parent schema to create a physical representation of what t...

Pivot table on local cube
Hi I have a pivottable that retreives some data from an Access database. When I double click some value in the pivottable Excel adds a sheet with all the data that concerns the value clicked. I also built a local cube using the same query that was used in the abovementioned pivottable. Unfortunately when I double-click some value in this pivottable a get a message that Excel cannot show details because this feature was disabled for this cube on a server. Is it possible to get this functionality with pivottable built from local cubes? Kind regards IgorM On Sep 23, 5:35=A0pm, "Ig...

I REALLY NEED HELP & ADVICE.... Local printing problem in Vista
Please advice me... I have been able to print using OS Windows 2000 on my laptop through my Canon printer BJC-50. I bought a new laptop that comes with Vista Ultimate, and when i plug in the USB from DB25 female parallel cable... I am unable to print. When i select print, it loads the paper and stuck there with the power light blinking. The printer is directly connected to my laptop. However, when I select cleaning, nozzle check and test page etc through the maintenance printer tab, it does proceed with its functions but prints: BJLSTART @CLEANING=1 BJLEND BJLSTART @TESTPrint=NozzleC...

Who could tell me about LPC(Local Procedure Call) and provide some examples?
Hello all: Who could give me some documents about LPC(Local Procedure Call) and provide some examples?There are examples on server and client.Thanks very muvh. ...

Schema Mappings
Hi All, I have a couple of questions on Schema Mappings... I've setup CRM so that when an account is made the user has the option of choosing what added extras the client has. Examples of this are: Anti Virus, Anti Spam etc. I've set this up as a simple drop down menu on the account General tab. I want this drop down menu to link with another similar menu I've created under the case (incident) General tab. I'd like to set it up so that when you change one it effects the other (ie change accounts and it changes the case drop down. I tried mapping the schema fields to achiev...

XML validate by XSD schema with C#
I am validating XML files on a server which has no internet access and the validadation in C# does not work. Schema with which I am validating has namespaces like: xmlns:ds="" xmlns:xenc="". I have these schemas all locally on the disk, but it does not work. If I try on a computer with internet access then it works just fine. Does someone know what to do. Function with which I validate looks like this: private bool ValidXml(string XmlFile, string XSDLoc, string tns) { // . . . string targetNamespaceU...

Schema Question
Hi, I am fairly new to XML schemas and why to use them. I am integrating with another application via xml. My questions are schemas only good to validate the XML documents or can I use the schema to help me parse the xml document? Thanks Well, following link will be useful to you. ~ Ankit randy wrote: > Hi, > > I am fairly new to XML schemas and why to use them. I am integrating with > another application via xml. My questions are schemas only goo...

changes address from .com to .local
I set up a distribution list in outlook, and whenever I send an email (all have been with attachments)it replaces my email address from .com to .local - any idea why, and how to make it stop? Not sure if it has to do with the attachment, or how I've set up the distribution list - although, retyping names into the "to" field and attaching the attachment (a simple word doc) has the same result. Nothing else seems to make it do this... any ideas? Thanks in advance for your help! Joni ...

"bank balance" vs "local balance"
In Money 2004, how do I get the account list to show the correct bank balance, rather than some silly "local balance", whatever that is? Thanks Mr S Mr S, The "local balance" is the balance of transactions you have entered (manually or electronically) into your account register. If you want it to match your corresponding bank account balance, you have to make sure you've included in the "local" register all the transactions that your bank has posted. This is no different than one balancing a paper checkbook. Of course, if your "local balance&qu...

Setting a reference to a schema doesn't work?
Hello NG! Using the System.Xml.XmlDocument I want to create such a xml-file: <?xml version="1.0" encoding="utf-8"?> <RootElement xmlns:xsi="" xsi:noNamespaceSchemaLocation="RootElement.xsd "> .... </RootElement> (That's what XMLSpy generates when assigning a schema to an xml-file.) I tried... pDoc = New System.Xml.XmlDocument pDoc.AppendChild(pDoc.CreateXmlDeclaration("1.0", "utf-8", "")) pRoot = pDoc.AppendChild(pDoc.CreateElement("RootElement")) ...

Turning off local mail delivery
Good Morning ... We are a subsidiary of a larger organization. The larger organization handles all mail routing and has created POP3 mail accounts for us on their server. We decided to install Microsoft Exchange in order to utilize public folders, shared contacts and local mail files. Unfortunately, local mail delivery is starting to be an issue. Seems that Outlook overrides the address that we put into the address field and delivers the mail locally whenever possible. This is a problem for our travelling salespeople who check their mail through POP3 (through the corporate mail ...

Where do I put my schema?
Hi, I'm developing a internet site for a customer. The customer is supposed to upload XML documents to the site and the documents shall be validated against a xsd schema. How do I publish the schema so that my customer may use it for namespace validation on their side? The site is an aspx site that has forms authentication. We do not want to put the schema on the site without any authentication. cheers, mortb It can go anywhere your client has the ability to find it. If you want them to authenticate, then put it behind that authentication. It's just a file, like an image ...

XP local NTFS permissions
I installed an app the other day on a PC that is part of a Workgroup. This app is different in that it doesn't update the registry, it can actaully be copied to the PC, versus running a setup program. So I was able to *install* it on this PC with a non-admin account. But, the user wanted there to be 3 logins on this PC, each one having a shortcut to this app. Did that. But it turned out only an account with admin rights or, the account that originally installed the app could run it. The app was copied to it's own folder off the root (C:\ThisApp) I believe this is a...

System Folders: Schema and schema-root
Hi, I have migrated from Exchange 2000 to Exchange 2003 (native Win 2000 AD-domain). Comparing PF -> System Folders with a clean Exchange 2003 Installation (native Win 2003 AD) I notice some differences in the System Folders; On the clean Exchange 2003: No 'Schema' system folder I renamed the Schema folder on the migrated servers and so far no problems. Is this folder still of any use in a Exchange 2003 environment? On the clean Exchange 2003: No 'schema-root\microsof\exchangeV1\exchweb and further. Because of earlier problems (There were 2 schema-root folders) I r...

How to create DB schema from XML schema
Hello All, We have XSD file with XML schema and want to generate database or SQL from it. Visual studio reads XSD file and shows everything graphically fine. Is there anyway, we could actually transfer the graphical information to database? Best regards, Neo ...

Users can't browse or see local site in GAL
My users cannot view RECIPIENTS CONTAINER objects, of our local EXCHANGE SITE, in the GAL. However they can still send email to users in our local site. Our site doesn't even show up in the GAL, but they can browse other Exchange Sites in the GAL. Now here's the kicker, Domain/Exchange Admins can view see the local site name in the GAL and browse to see the recipient containers within the local site. This leads me to believe that permission some how got screwed up. But, nothing jumps out at me! Thanks for the support, BR Check out

How to move all dbo schema objects to another schema?
Does anyone know of a way to move all objects in a db from schema dbo to another schema? mat (mat@notarealdotcom.adr) writes: > Does anyone know of a way to move all objects in a db from schema dbo to > another schema? In theory: SELECT 'ALTER SCHEMA newschema TRANSFER dbo.' + quotename(name) FROM sys.objects WHERE schema_id = 1 Excute and run result. But before you go ahead, beware of that in practice it is a lot more difficult. For starters you should probably add a WHERE clause to the SELECT, so that you don't include object types like cons...

No Schema Manager in Deployment Manager 3.0
Folks I've got a weird one - I can't find Schema Manager! My Deployment Manager has 3 nodes - Server Manager, License Manager & User Manager. Has this moved in 3.0? Cheers Hany Answered my own question - Settings | Customisation | <<Entity>> | Attributes Interesting - does that mean that some of colleagues get a change of job title - Attribute Administrators? ;-) "Electronic Workplace" <> wrote in message news:u4yH0xj8FHA.4036@TK2MSFTNGP11.phx.gbl... > Folks > > I've got a weird one - I ...

Modular schemas
I'm working with the w3c's "Modular Xhtml schema". The problem I have is that when I try to add the Schema Driver File to my schema collection, I get the following error: "Cannot resolve schemaLocation attribute." The error occurs on the first <xs:include schemaLocation="xxxxx.xsd" />. The only way I have been able to fix the problem is to use a fully qualified file path i.e.: <xs:include schemaLocation="file://D:\\myFolder\mySchema.xsd" /> There HAS to be a better way. If any of you have looked at modular schemas, or even used AN...