Capitalization of table feature class name

Question

Dear All,

I have found very few posts related to my issue. The issue was SDE always returned me a capitalized table feature class (like WATERQUALITY), but a mixed upper and lower case name (WaterQuality) is what i preferred. I contacted ESRI support and was told that SDE has the ability to store a table feature class with mixed cases. I was asked to install the SP 2 (V9.3.1 SDE and SQL Server 08) and the same issue. I can test altering the collation of the database, but want to see if anybody already had the same issue and could your experience. I appreciate any replies.

Thanks 
Russel

ducksunlimited · Answer

Kimberly, thanks for letting me know.

Russel
Russell,

Don't change the collation of your database; case sensitive (CS) database collations are not supported with ArcGIS.

KimPeter · Answer

Russell,

Don't change the collation of your database; case sensitive (CS) database collations are not supported with ArcGIS.

ducksunlimited · Answer

Yes, I could take an extra step to manually change the name after I created or imported a new table, but I just wonder why the name was capitalized after I first created or imported a table into the SDE?

Since case sensitivity is controlled by the collation of the database, I want to alter the default CI to CS to see if that will solve the issue or not.
I've never had a problem with it; all my feature classes are mixed case.  I use SQL Server Server 2008 R2, and before that SQL Server 2000.

Why would you need to change the collation of your SQL db?  I'm just not sure that a collation in your db has any bearing on mixed case file names. Why not just change the names to how you want them in ArcCatalog?