Collation Issue

galland1928

A month ago we upgraded from SQL 2000 to SQL 2005 and from NAV 4.01 to NAV 4.03 Update 6.

Since then, several of our users noticed that when they pull up the item list, the items aren't in the right order that they are used to. We identified that there was a collation issue that caused this and to restore our db.

We restored our db this weekend thinking the collation issue would be fixed but it is still there.

Here is a copy of the table definition (correct me if this is the incorrect term) of our db with the collation issue:

CREATE TABLE [dbo].[Live db$Item](
[timestamp] [timestamp] NOT NULL,
[No_] [varchar](20) COLLATE Latin1_General_CS_AS NOT NULL,
[No_ 2] [varchar](20) COLLATE Latin1_General_CS_AS NOT NULL,
[Description] [varchar](30) COLLATE Latin1_General_CS_AS NOT NULL,
[Search Description] [varchar](30) COLLATE Latin1_General_CS_AS NOT NULL,
[Description 2] [varchar](30) COLLATE Latin1_General_CS_AS NOT NULL,

Here is a copy of the table definition without the collation issue:

CREATE TABLE [dbo].[TEST db 11-15-07$Item](
[timestamp] [timestamp] NOT NULL,
[No_] [varchar](20) NOT NULL,
[No_ 2] [varchar](20) NOT NULL,
[Description] [varchar](30) NOT NULL,
[Search Description] [varchar](30) NOT NULL,
[Description 2] [varchar](30) NOT NULL,


Any idea's on how to fix this or what could have caused it?

Thanks

kine

For me it looks like one way is to do NAV backup and restore to have correctly created tables.

galland1928

Kine, thanks for the response.

We actually did run this restore process this weekend hoping it would fix this issue, however it did the same thing.

galland1928

Any idea's anyone? :?

ara3n

was this done through navision backup and restore or sql backup and restore?