• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

MS SQL-Server and case-sensitive meta data...

During the installation, one can choose settings to force case sensitive meta data in MS SQL-Server.

Q1: Is this statement through? If so, what version of SQL-Server this feature is started?

Q2: At what stage this setting takes place? Can the setting change after installation?

 hope you don't mind double questions in each line.

Thank you.

Mike Eghtebas
Mike Eghtebas
2 Solutions
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the answer is: the character set installed (for master db) is what determines the case sensitivity.
so, indeed, during installation, you specify this by selecting the character set you want to install.

you cannot change that later (for master db) ...
For SQL Server:

Q1: True--yes.  Not sure when it started, but definitely available in 2005;
Q2: As you noted, it's an installation option that affects the collation for system tables. You can use alter table to change the collations, but it's tricky business and I advise against attempting it unless you have a serious internals expert on board.  You are better off to create a new installation and import your databases to it.

PS. You may have inadvertantly posted in the wrong zone.
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Thank you for noticing wrong TA and moving it to MS SQL Server.

I appreciate the comments.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now