Post reply

List Collation on database

  • August 23, 2011 at 8:23 am

    #256059

    Hello,

    I am setting a new databases and I don't know which collation to set up and where to get list of collations.

    I will have diffirent languages coming to my database,including English.Which collation I need to set up?

    Thank you

  • August 23, 2011 at 8:31 am

    #1372045

    the function below returns all possible colaltions on your server ...much more than i care to digest .

    the second query is just the collations currently in use.

    hope that helps:

    select * from ::fn_helpcollations()

    select name, collation_name from sys.databases

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 23, 2011 at 8:46 am

    #1372060

    Thank you

  • August 23, 2011 at 8:52 am

    #1372066

    i don't think the collation is going to affect you at all, you should use the default server collation, you just have to use nvarchar columns everywhere instead of varchar, so you can capture the extended ascii stuff, right?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 23, 2011 at 9:27 am

    #1372093

    Lowell (8/23/2011)

    i don't think the collation is going to affect you at all, you should use the default server collation, you just have to use nvarchar columns everywhere instead of varchar, so you can capture the extended ascii stuff, right?

    depends, for instance if you have currency values coming in in French you probably want French collation.

    1,000.00 in French is actually 1.000,00

    Check with your application vendor

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 23, 2011 at 10:41 am

    #1372153

    Thank you, I only have string data coming

Viewing 6 posts - 1 through 5 (of 5 total)

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