Upper/lowe case set in server wide

[ravi]

Hi,
Can we set the Uper/Lower case in server wide in SQL server 2000 as like case sensitive.
Thanks,
Ravi

[Stephen]

This can be done as the default for the server. This can only be done at installation time though. If you have an existing installation, you will need to re-install SQL Server.

You will need to specify a case sensitive collation.

[MAK]

server wise - you have run setup and change the sort order to case sensitive

database wise - alter database

column wise - alter table


http://www.databasejournal.com/featu...le.php/3302341

[ravi]

My request is that alwasy the server should take an Upper case even if I'm entering a small letter or lower case even if i'm entering upper case.
Do you think we can set up like this.

[MAK]

You mean SQL Server should convert whatever you type to an uppercase and the whole database,tables, columns, rows should be converted to an uppercase values.

SQL Server by itself cannot do those conversion. You have to create triggers on tables to do that. (that is one way)

Question: What is the advantage in doing that? Why you want to do that?

[ravi]

You mean SQL Server should convert whatever you type to an uppercase and the whole database,tables, columns, rows should be converted to an uppercase values.

-----Yes MAK, you are correct that's what our expectation. We have a businsess request that need to have everything need to write into database as a Uper Case.

[rmiao]

Or insert rows like this:

insert Table values(upper('text'), ...)