Skip to Content
0
Former Member
Jan 07, 2011 at 02:07 PM

Accent Insensitive collation issue

126 Views

Hi there.

I'm using visual studio 2005 crystal reports and sql server 2005.

I believe crystal reports is not using sql server's collation for accent insensitive. When I use a RecordSelectionFormula such as:

" Like 'as'" the report is not showing data such as "ananás", although sql server is set to Accent Insensitive, which is a huge problem in our case.

Is there some way to solve this issue?

TIA