Post reply

Converting all data to UPPERCASE

  • June 8, 2009 at 11:51 am

    #205143

    We have a need to take a large database with 100's of tables and require that all fields be stored UPPERCASE. I started out with a Collation setting, but quickly realized that didn't affect the underlying data. I suggested triggers, but there have been some objections amongst our developers to the use of triggers. Any other quick global setting that I haven't stumbled upon that might be out there?

    Thanks.....

  • June 8, 2009 at 12:12 pm

    #1006231

    SuzDBA (6/8/2009)

    Any other quick global setting that I haven't stumbled upon that might be out there?

    Nope.

    Enforce through triggers, enforce through stored procedures (and make sure nothing directly accesses the table) or enforce in your front end app.

    p.s. Why force the data to be stored in uppercase? Why not use a case insensitive collation and change the queries so that the data's returned in uppercase?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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