Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 69
	Members: 1
	Total: 70

	Online Now:
	Aroma

New Topics

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

SQL 2008 collation

2 Replies

0 Subscribed to this topic

29 Subscribed to this forum

Sort:

Author

Messages

mcm1

New Member

Posts: 4

7/28/2010 2:08 PM

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

Posts: 3366

New Poster

Engaged Reader

Avid Reader

7/28/2010 2:47 PM

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.

mcm1

New Member

Posts: 4

7/28/2010 3:15 PM

thanks- that was exactly what I wanted to know