Post reply

SQL server will bring back the wrong search result when run the command line which includes I or i

  • September 3, 2012 at 6:48 pm

    #261330

    Hi,

    I’m using SQL server 2008R2, version number is 10.5, in Turkish. I have setup a database and use the Turkish_CI_AS as its sort mode. But one problem happened, when I run the SQL command, if the SQL command includes the letter “i” or “I” will bring me the wrong search result, any help? Thanks in advance.

  • September 3, 2012 at 8:30 pm

    #1533098

    bigantsoft (9/3/2012)

    Hi,

    I’m using SQL server 2008R2, version number is 10.5, in Turkish. I have setup a database and use the Turkish_CI_AS as its sort mode. But one problem happened, when I run the SQL command, if the SQL command includes the letter “i” or “I” will bring me the wrong search result, any help? Thanks in advance.

    Use the COLLATE statement with a binary collation type on the search.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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