Collation Type

Fisherman

Another question for the gurus....

Our NSC set up our Navision databases with a Windows collation type. The case-sensitivity is driving me bananas, though. I can foresee users looking up items and not finding them because they weren't using the proper case, then proceeding to create a new one.

Does changing the collation type to SQL collation help this issue? Does it cause problems in other areas of Navision?

Thanks.

ara3n

I wouldn't want to change collation just for the searching on item card.
It will effect on sorting etc.
you can search on Search Description which is of type code, and it's all uppercase and not case sensetive. Or you can modify the record to convert everything to uppercase.

Fisherman

Searching for items was just an example of problems I could see in the future... I was just wondering what kind of problems changing the collation type would cause.

ara3n

It will effect sorting.
Also any code that expects that expects the records to be case sensetive will behave differently. I can't think of a place in navisition that does that.

Miklos_Hollender

I think the best collation is the binary one, not the Windows or SQL. The problem with Windows collation is that it uses grammatical rules. F.e. on a Hungarian locale, you have Item No. FCSG01 and you filter for *SG* it won't find it because it expects the CS be the "cs" double-letter and not "C" and "S".

DenSter

The way I personally do it is I figure out how it works and I deal with it. Once I know that search is case sensitive, I adjust the way that I search accordingly.

Miklos_Hollender

And then put on your mind control helmet[1] to reprogram the brain of 100 users to search the same way

[1] Sorry, just been watchin' the X-Men movie

DenSter

LOL, where I come from we call that 'user training'.

Miklos_Hollender

What I tried to point out is that it's usually easier to change software to behave the way people expect it than to make people use something that behaves illogically

ara3n

I don't know if you know about this but if you cilck on file->database->alter->Collation tab-> Just untick the Case-sensitive checkbox.

Miklos_Hollender

OK, a bit more complicated than that. First kick all users, set database to one user only etc. I think it's in the F1 help there.

ara3n

Ofcourse you want to do this in you test environment first and test and make sure it works and then do it at night when nobody is around.