Find Field Case Sensitive on Navision SQL Migration V.3.10

tranceport

Hello!

I have recently migrated a Database Version 3.10 to SQL.

Problem is while i was trying to search for a description in the item list, although the setting of "Match Case" is UNTICKED, Navision still does not find the Description.

I.e. Description = 'ADESCRIPTION'

if i type in the find window 'adescription' it is not found.

Any Suggestions??

Thanks

Tranceport

ara3n

You need to select a collation that is case sensitive.
Go to file->database->alter->Collation tab->

Make sure case collation tab is setup correctly.