Forum Replies Created

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

  • RE: Bug in charindex?

    It is indeed the collation setting. I had mine set to Latin1_General_CS_AI and the
    issue occurs with this setting. Setting the collation to something else
    (SQL_Latin1_General_CP1251_CI_AS for example) and...

    May 28, 2006 at 6:22 pm

    #640518

  • RE: Bug in charindex?

    yes, that is supposed to be the expected result. On both my SQL 2000 and SQL 2005
    however, I always get  qwertyuiuoip  only.
    Clutching at straws here but could it be some...

    May 25, 2006 at 6:26 pm

    #640209

  • RE: Bug in charindex?

    Hi Paul,
    thanks for the reply. I already have the column width set to 256 by default.
    I've tried several variations on the string including putting the 'th' at the front
    and it always truncates...

    May 25, 2006 at 12:36 am

    #639961

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