Navision 4 Microsoft SQL Server - case insensitive

davmac1

Is it safe to set up Microsoft SQL Server 2000 as case insensitive for Navision 4.0?
This would make it easier for our non-Navision applications.

Has anyone have any experience doing this or any warnings?

sporri

You can always install the Server itself case insensitve as long as the Navision Database itself is case sensitve, any client after 3.60 can create the datebase with a different codepage from the one the server has as default. and if you are using an older version you can create the database elswhere with the correct codepage and then use detach/attach to install it on the other server.

But for the database itself, keep it case sensitve you get all kinds of errors if you dont.

Sporri

davmac1

We are wanting to make the Navision database case insensitive because we will be using a common database for our .Net web based application.

What types of errors do you get if the Navision database is case insensitive?
If we start a new Navision database with case insensitive, will we still have problems?

DenSter

One problem you will have for sure is with the proprietary Navision 'Code' datatype, which is case sensitive. One of our customers had a corrupt database because they had entered data directly into the Navision SQL tables, and used lower case characters in Code type fields. Navision can't read lower case characters in Code type fields and it will shut down when it happens.

davmac1

You can have the same problem with CODE fields in case sensitive databases.
What I would like to know is - providing we follow Navision data rules - is there any problem with a SQL Server database for Navision being case insensitive?
As far as I can see it should only affect SQL Server keys, joins, and where clauses.

DenSter

Filtering in Navision is case sensitive as well.

davmac1

Would filtering be affected by the database being case insensitive? Does Navision build SQL Server keys for filters?

Can you think of any time when you wanted to do a case sensitive filter on a text field? Usually with names, descriptions, cities, etc. youwould want a case insensitive filter.

DenSter

I will just let you figure it out yourself then.

fl

Hi,

I use 2 navision sql databases, case-insensitive, for more then 2 years (version 3.6 and 3.7). I've never found for these reason any problem in the application. I really prefer that way because filtering is easier (never even to think about the case).

The point that DenSter noticed about using lower case characters in code fields is true. Sql manager has no problem to look at the data in lower case, but the navision application will give an error. But this has nothing to do with the fact if you are using case-sensitive or not.

Francois

davmac1

Thanks - that is what I was looking for was some practical experience or examples on why it would or would not work.