Collation and Sort Order, etc...

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Collation and Sort Order, etc...

Author

Topic

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2008-03-16 : 06:34:31

New SQL Server 2005 install (Stnd edition with SP2) and the Vendor for the Application Software has these requirements:

MS SQL Server SP2 with FULL Text Indexing and Natural Language Query. Collation SQL_Latin1_General_CPI_CI_AS; Date settings Month/Day/Year

When I installed SQL Server I basically installed the Default Collation of SQL_Latin1_General - is that different from their requirements???

Also, not sure about Natural Languarge Query AND the date settings??? is Natural Language Query installed by default and how do I check or change the Date Settings????

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-03-16 : 11:48:27

for installing english query:
http://msdn2.microsoft.com/en-us/library/aa176566(SQL.80).aspx
for date settings you need to do:
SET DATEFORMAT MDY

but you can tell that this app is poorly built just from the date format requirement.
SQL_Latin1_General is case insensitive so your equal operations won't match for same strings of different casings against values with SQL_Latin1_General_CPI_CI_AS.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2008-03-16 : 19:45:33

Thank you for your help!!!!

you said "SQL_Latin1_General is case insensitive so your equal operations won't match for same strings of different casings against values with SQL_Latin1_General_CPI_CI_AS"

so how do I fix the colation?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-16 : 22:47:19

You can change db collation with 'alter database'.

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2008-03-17 : 09:36:14

When I install 2005 on the next Server, how do I set Collation SQL_Latin1_General_CPI_CI_AS; Date settings Month/Day/Year at install time?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-17 : 23:16:09

Choose custom install, you can pick collation there. Don't think you can set date format during installation.