Post reply

SQL2008R2 Intellisense auto-complete column list case sensitive??

  • November 3, 2010 at 2:44 am

    #225753

    I found out by accident that the column list shown by Intellisense autocomplete is case sensitive ? What sense does that make? No 'intelli' sense to me, anyway ...

    So for example, I have a table 'table1' with these columns:

    fieldA

    fieldB

    fieldC

    FieldD

    FieldE

    moreFieldsA

    moreFieldsB

    When now using a SELECT on 'items', and using table1. + SPACE to show the members, it will show this column list sorted like this:

    fieldD

    fieldE

    fieldA

    fieldB

    fieldC

    morefieldsA

    morefieldsB

    My database collation is set to Latin1_General_CI_AS

    This makes no sense to me, why would Microsoft make this functionality case sensitive !!?

    Is there a way to just show the column list in a normal sorting order ?

  • November 3, 2010 at 7:13 am

    #1245967

    I think they implemented the intellisense to work with any kind of collation, so that it sorts field names with "binary" sort instead of using database collation settings.

    I don't think there's something you can do about it.

    -- Gianluca Sartori

  • November 3, 2010 at 7:17 am

    #1245971

    Thanks for replying. It would be very bad, when you are right ... :crazy:

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

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