collation problem

leon1983
leon1983 Member Posts: 20
edited 2007-08-12 in SQL General
Hello

I have a problem with setting up collations for an SQL server.

I am entering german names and polish names in my server, so I need a collation that does multiple European languages, but I only have either german or polish collation. So when I use the german collation, I cant enter the polish names, and vice versa.

Does anyone know where I can find a collation that does multiple languages?

I need german polish english french spanish tchek danish and swedish. (I know its a lot).

thank you !

Comments

  • mihai.valcea
    mihai.valcea Member Posts: 95
    Hello,

    I have same problem with Romanian and German and I did not found a collation for both.

    Maybe someone did !!

    Mihai
  • Mojito
    Mojito Member Posts: 9
    Hi,

    As far as I know not possible.
    Besides our West-European countries we are also using NAV in Poland, Czech.
    If you create a DB from a NAV client all the fields are defined as non-unicode (ex. char, varchar, text).
    If you use unicode definitions (ex. nchar, nvarchar, ntext) then you should be able to support all languages. In case of non-unicode (the way NAV is working) your OS language codepage where the NAV client is running on is the key player.

    The only solution I have found so far is to use a Polish or Czech Windows OS with an English NAV Client and then are able to write/retrieve Polish/Czech characters.

Categories