key sensitive search after migration to sql database

mauro66

hi,

after migrating a navision 3.6 database to sql 2000 the search function inside navision is key sensitive.
someboyd know how to set it non key sensitive ?

](*,)

mauro

DenSter

Uncheck 'match case'?

mauro66

i did but the problem persist

](*,)

DenSter

Then it's in the collation page you selected on the SQL Server database. I have no experience in selecting a different one on an existing database, so I could not tell if it is safe to change it now.

ara3n

Hello Mauro66. It is safe to change collation on database. It'll take a while, because all the keys have to be rebuilt. I have customers who have done it because other databases they had, had different collation, and you can't have views accross different databases with differnt collations, so they had to change navision collation.

kriki

[Topic moved from Navision forum to Navision Attain forum]