Sorry for those who keep reading my posts about Unicode (you can tell it's a focal point for me at the moment!)
But I assume that unicode is still an issue if you move from Native to SQL Server, as it will be the code pages from Navision that will interpret the data being read? i.e. Is the Unicode read correctly in SQL Server, but viewed incorrectly on the NAV client??
0
Comments
2) If you are restoring the data into SQL, I am not sure, but for me there are two ways (and I do not know which is used) but I will try to describe the one, I thing which is used:
Nav will take the data from backup, the character is saved as no. 172, Character no. 172 is send into SQL, and because in SQL you have Latin 1 as codepage in the collation, the character "¼" will be saved in the DB. If you have Latin 2 as codepage in the collation (e.g. when using windows collation Czech), the character "Č" will be saved in unicode.
3) And when you connect the NAV client to this DB, e.g. when SQL is using Latin 1, but your windows are set for Latin 2 for non-unicode applications, NAV will receive character "¼" from the SQL, but because there is no such a character in Latin 2 codepage, ? will be showed...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
We have a 5.0 BE database where we want to add Czech company. All works fine, we have added some local reports in order to be legally compliant,...
The only thing that shows up is that the special czech charakters don't show up when typing them.
We work over Citrix for all countries, and 1 DB. We have been playing around with collation on the database (via Nav client - alter DB) but also with collation on SQL. We noticed that on a new SQL DB (not Nav) we can type and save special char, but doing the same via SQL directly in one of the NAV tables, the charakter is converted back to Normal char....
Any idea how to setup?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Well, I'm not sure if that's applicaple for this issue, but there is an option to enable "Double Byte Characters" in NAV: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;915374
Maybe this helps ...
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
1. Save as HTML does not work with Unicode
2. Implementation for multiple Unicodes not possible using same workstation without changing Language for non-Unicode programs (restart required for each change)
3. Sometimes certain characters can never be entered directly into Nav (it becomes another character, or funny character), but the correct character will be fine in notepad, Word, etc
ERP Consultant (not just Navision) & Navision challenger