You’re offline. This is a read only version of the page.
265
NAV2013R2
When I change collation from Finnish-Swedish Case Sensitive to Finnish-Swedish Case Insensitive nothing happens in the database. In NAV client the change is reported as successful, but in SQL-server nothing has happened, it is still case sensitive.
When I start NAV servern again and connect with RTC, NAV server starts working with what seems to be changing the collation. But when finnished collation is still the same.
Are there any problems with collation change in NAV2013R2?
What is the procedure on how to change collation and what is actually happening in the dev client and on the NAV server?
Regards Fredrik
*This post is locked for comments
Thankyou Jens,
This is the link to Mibuso topic:
www.mibuso.com/.../viewtopic.php;t=59489
There is a workaround that leave me in some doubt.
I will ask Microsoft about the status of this what seems to be a bug after all.
Follow..
msdn.microsoft.com/.../hh168537(v=nav.71).aspx
www.mibuso.com/.../viewtopic.php;t=59489&start=0
-Saurabh Shah
Hi Fredrik,
yes there apparently is: www.mibuso.com/.../viewtopic.php;t=59489&start=0 Also some sort of workaround is proposed, but not sure if it is safe. In versions pre-2013R2, you could do a .fbk backup and restore into a new database with the new collation (if the data fits). Not sure if the nav-savedata/nav-restoredata cmdlets work in this scenarion, I would assume not. :(
with best regards
Jens
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
