Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Mon, May 14 2007 11:12 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim If a column is defined as (say) ANSI_CI and I want a case insensitive comparison I seem to recall you said I wouldn't need to do anything. If the collation was defined as ANSI I'd have to add COLLATE ANSI_CI to the test. My question is, if the collation is defined as ANSI_CI does adding COLLATE ANSI_CI have any impact on performance? Roy Lambert
Mon, May 14 2007 5:45 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << If a column is defined as (say) ANSI_CI and I want a case insensitive comparison I seem to recall you said I wouldn't need to do anything. If the collation was defined as ANSI I'd have to add COLLATE ANSI_CI to the test. My question is, if the collation is defined as ANSI_CI does adding COLLATE ANSI_CI have any impact on performance? >> No. -- Tim Young Elevate Software www.elevatesoft.com