Storing data in other language

Last post 11-11-2009 4:32 AM by TATWORTH. 4 replies.

Sort Posts:

  • Storing data in other language

    11-07-2009, 1:40 AM
    • Member
      2 point Member
    • bhavnvyas
    • Member since 11-05-2009, 9:07 AM
    • Posts 2

    Hi all,

    I have to store data of other language using Linq.

    plz help....

    thnx in advance

     

     

      

  • Re: Storing data in other language

    11-07-2009, 11:12 AM
    • Participant
      1,639 point Participant
    • vishwaraj1
    • Member since 11-07-2008, 7:44 PM
    • India
    • Posts 423

    so what is the problem if you are using other language...

    or you have confusion in Linq..

    Regards:

    Vishwaraj Malik

    VB to C# Converter


    Please: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue.
  • Re: Storing data in other language

    11-07-2009, 11:32 AM
    • All-Star
      62,811 point All-Star
    • TATWORTH
    • Member since 02-04-2003, 8:34 AM
    • England
    • Posts 12,256
    • TrustedFriends-MVPs

    What is your backend database?

    Are you storing the string data in a National data type e.g NVARCHAR and not VARCHAR

    Don't forget to click "Mark as Answer" on the post that helped you.
    This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped.
  • Re: Storing data in other language

    11-11-2009, 4:26 AM
    Answer
    • Member
      226 point Member
    • ashokkumargv
    • Member since 07-06-2009, 7:20 AM
    • Posts 38
    Hi, the scenario invoving multiple languages within the same table,then you have to choose the Unicode nchar, nvarchar, and nvarchar(max) data types is the best choice. Thanks and Regards Ashok Kumar
  • Re: Storing data in other language

    11-11-2009, 4:32 AM
    Answer
    • All-Star
      62,811 point All-Star
    • TATWORTH
    • Member since 02-04-2003, 8:34 AM
    • England
    • Posts 12,256
    • TrustedFriends-MVPs

    To store any non-english language (whether one or many), you need to use:

    • NVARCHAR instead of VARCHAR
    • NCHAR instead of CHAR
    • NTEXT instead of TEXT (however NTEXT/TEXT is dpreciated and you should use NVARCHAR(MAX)
    Don't forget to click "Mark as Answer" on the post that helped you.
    This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped.
Page 1 of 1 (5 items)