elarrat
SSC Rookie
Points: 46
More actions
July 25, 2002 at 10:20 am
#357579
Hi,
I need to modify my database (sql Server 2000) to a case-insensitive (Now it is set up to a binary sort).
Would you please help me?
Elarrat, JIA,
o Portimoteco!
Elarrat, JIA,o Portimoteco!
Andy Warren
SSC Guru
Points: 119902
July 31, 2002 at 6:08 pm
#433752
I've never tried to do it, have you looked through BOL? I think you can change it by bcp out/back in. I always use case insensitive to start with, then adjust the collation at the column level if needed.
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply