Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Collation Error 468 RE: Collation Error 468
Rachel Byford
Hall of Fame
Points: 3437
More actions
February 18, 2008 at 7:59 am
#779328
I've had occasion to use COLLATE when I needed an accent insensitive search (I needed to find é as well as e when the user typed e), when all of our data has accent sensitive collation. The collation name has _AI on the end instead of _AS.