Post reply

Change text format from case sensitive to case insensitive

  • August 31, 2015 at 10:28 am

    #307237

    How can I change my T-SQL text editor from text sensitive to text insensitive?

  • August 31, 2015 at 10:48 am

    #1823420

    NineIron (8/31/2015)

    How can I change my T-SQL text editor from text sensitive to text insensitive?

    assuming your text editor is SQL Server Management Studio, SSMS itself is not case sensitive; however, the database you are connecting to might be , based on it's collation.

    collation is what makes it case sensitive, and most likely, you would need to modify the databases' default collation, and modify every column in the database that is using a case sensitive collation; if it's production, you need to go through a decent change control process, as this sounds like a work around for an annoyance, rather than a business need.

    if there's an constraints, defaults, foreign keys or indexes on any of those case sensitive columns, it makes the modification substantially harder.

    if you are working in a case sensitive database, you'll have to code that way as well.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 31, 2015 at 10:53 am

    #1823422

    Thanx.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply