When you enter in a new client name, or a new part number or a new unit’s serial number, AyaNova checks to see if there is an existing record already entered into AyaNova with that same name or number. And AyaNova let’s you know so YOU decide if you want to have duplicates or not.
Whereas IF you enter a new client name, or a new part number or a new unit’s serial number, BUT use a different case then the original AND you do NOT receive a pop up window from AyaNova letting you know there is an existing record with that same (client name, or part number or unit’s serial number) this may be because of the database configuration you are using and its collation setting.
If using SQL (Express OR Server) and you do not receive notification of an existing record when entering with a different case:
Check the “Collation” setting for your AyaNova SQL database to resolve it.
The default should be the standard SQL_Latin1_General_CP1_CI_AS setting.
To check your Collation in SQL Management Studio right click on your AyaNova database, select Properties and in the first item under General in the “Maintenance” section.
If using Firebird (stand-alone or networked Firebird Server) and you do not receive notification of an existing record when entering with a different case:
Update to AyaNova 7.2.0.0 Hotfix 3 as AyaNova will force Firebird to check both cases when language is English