Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Cergy
    Posts
    65

    Question Unanswered: Multilingage/multi charset (latin/greek...) in 1 DB ?

    Is it possible to have in the same MsSQLServer database several languages:

    French, english, german, spanish... (latin langages)
    but also langages with different characterset (greek, cyrilic...)

    What should be the type of data (char ou nchar(unicode)) ?
    what should be the colation ?

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Yes check books online for UNICODE & COLLATION topics for further information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you want to "mix and match", you'll have to use Unicode (NCHAR, NVARCHAR, and NTEXT) columns. They allow you to have Greek in one row, Cyrillic in another, Latin in the next, and Kanji or Hiragana to top things off!

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •