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
 Database Design and Application Architecture
 how to manage multilingual data

Author  Topic 

prashant_sharma1984
Starting Member

1 Post

Posted - 2008-04-12 : 14:44:05
Hi Fellas,

I have a problem and it is described as follows:

1. The user may browse any website on the internet that may be in any language and enter the data into my application.
2. The data entered can be in English or any other language.
3. That’s were the problem arises; the data that enters the database other than English is displayed in wrong format like small boxes.
4. The user who had previously entered the data in the database can also alter that data. So when I display the data (other than English) to him it is not in the format in which the user had entered.

So can anybody help me out how to manage multilingual data?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-12 : 15:28:02
Use NVARCHAR data type.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

gayoosoftware
Starting Member

8 Posts

Posted - 2008-04-21 : 17:03:04
you have to use unicode enabled datatype like NVARCHAR
Go to Top of Page
   

- Advertisement -