Several languages in the same server....

  • Hi everybody

    First of all, I must say that this is my first approach to collations, languages , sort orders, etc and thinks like that

    I work in an international company, that works in different countries all over the world. Before now, we haven't had problems with languages because, almost everything was in spanish or english, so we can store all the data correctly. But now, We have to store german messages in tables, and I don't know what to do. Because the apllication is still in english but some columns must show german characters.

    What do you recommend me?

    We'll have to store chinese in three months time !!! so, i wonder if there is a way to be prepare to store this data in the same server.

     

    Thank you very much in advance!!! (and sorry for my english)

    Julia.

  • - you could go for N(var)char solutions and avoid collation issues.

    - if you're using a database per collation, _all_ interdb stuff has to perform collation translation to be compatible. Check out http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=95954

    - if you're choosing for a collation per column, offcourse if you want to compare colx to coly you'll need to perform collationtranslation.

    If you only want e.g. have some translation tables like

    create table mytranslations (

    code1 char(4)

    , UsEnglishtext varchar(256) COLLATE SQL_Latin1_General_CP1_CS_AS

    , Germantext varchar(256) COLLATE German_PhoneBook_CI_AI

    , ChineesText varchar(256) COLLATE Chinese_Taiwan_Stroke_CI_AI)

     

    code1 UsEnglishtext, Germantext, Chineesetext

    aaa     mytext          meintekst     "number43"

    There may be no problem if your queries don't mix collations.

    I hope this gets you on track ...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Ok! I'll try to use unicode strings... 🙂

    thank you very much!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply