key sensitive search after migration to sql database

mauro66
mauro66 Member Posts: 9
edited 2006-01-17 in Navision Attain
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

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Uncheck 'match case'?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • mauro66
    mauro66 Member Posts: 9
    i did but the problem persist

    ](*,)
  • DenSter
    DenSter Member Posts: 8,307
    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.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ara3n
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to Navision Attain forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories