Globalisation and Localisation issues in ASP.NET , TSQL, C#, Javascript

Question

0.00/5 (No votes)

See more:

I am working in a Globalisation project where I need to support an existing project into various languages such as Japanese, Germany, Italian and much more. Regarding the Resource management I create resource files and handled it successfully. Regarding the database side I aware I need to change varchar to NVarchar. I have below queries. The list is big one please bear with me.

1. How to store and retrieve DATETIME value to and from SQL database for each culture?
2. How could I retrieve values from database table to show values in a DROPDOWN list?
3. How GRID data should be handled?
4. How to implement SEARCH and SORT operation to be handled for each culure seperatly?
5. Is there any way to implement Spell check for each language?
6. How to implement VALIDATION part for each culture?
7. Some of the Third party controls are being used in the project which return results in Standard english. How to implement Globalisation on Third party controls?

Any help is much appreciated. Thanks.

Posted 24-Aug-11 23:01pm

Member 3137078

Add a Solution

Comments

Ed Nutting 25-Aug-11 5:35am

I can answer number 1 - use UTC time for stroing in database and search google for converting utc to/from local times in c# - it's not hard.

5 is not possible unless your willing to write a spell checker for every language, and Microsoft haven't even got that 100% yet :/
6 - if you mean validating if there is content or not then that's the same for any culture, if you mean validating what the content is then that's like above, unless your just validating a date format which can be done.
7 - Only if the Third Party Controls implement such a feature or you write your own translator or try sending the content to google to be translated then displaying the response but we all know google translate isn't very good :/ In other words, yet again you are asking the impossible...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Niral Soni · Answer 1 · 2011-08-25T01:41:00

Solution for Question-2 and Question-3:
possible solutions -
(A) Add one more column to your table - language_id. Modify your primary key, and add language_id also as a part of your primary key. Create multiple entries of the same record with different language specific values. So, when you retrieve your data, you need to pass language_id also along with the present primary key value.

(B) Make use of the properties file like - labels_en.properties, labels_fr.properties etc. and make use of the key in these property files for fetching the language specific values.

(C) If your project is internet based, you can make use of the Google Translation service directly, which can convert your existing web page into desired language, just by adding small piece of block in your code.

Thanks & Regards,
Niral Soni