SQL 2008 collation

Sort:
You are not authorized to post a reply.
Author
Messages
mcm1
New Member
Posts: 4
New Member
    Hello-

    I know that Lawson DB's require a collation setting of Latin1_General_Bin. But does it matter what the actual server setting is or can you take the default in the installation?

    MS SQL Server 2008

    thanks
    John Henley
    Senior Member
    Posts: 3348
    Senior Member
      You can take the default, but will need to remember to change the collation every time you create a database.
      People frequently forget to do that, which is why it's easier to change the default if the only databases on the db server are for Lawson.

      Thanks for using the LawsonGuru.com forums!
      John
      mcm1
      New Member
      Posts: 4
      New Member
        thanks- that was exactly what I wanted to know
        You are not authorized to post a reply.