Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Chinese database conversion from 5.0 to 2013R2
elnowako
Member Posts: 12
Hi All,
I am trying to convert Chinese database from 5.0 to 2013R2.
I have there a lot of chinese characters which are stored in the db in a different way than the standard characters.
As a first thing i checked how the data looks in the SQL Sever, this is quite big mess.
Data presented in SQL Server is completly different that in the Navision 5.0, some strange characters, but in the Navision 5.0 when I open table everything looks perfect.
Conversion task is done with these steps.
1. Technical conversion to 2009R2 (Chinese characters are still visible when I check in the Navision table, but in the SQL Server I can't see Chinese Characters)
2. Technical conversion to 2013 (I can't check how the data looks like in the Navision, but in the SQL Server is still mess)
3. Technical conversion to 2013R2 (after I imported all necessary objects I was able to connect db to the service and open table) As you can expect data presented in the RTC Navision table is not what I had in 5.0. Chinese characters were replaced with some strange digits, i can see the same "strange" characters like on SQL Server.
Is there any person here who has some expirence with this kind of conversion?
I am looking for some tips how to convert this db from 5.0 to 2013R2 and keep there Chinese characters.
Thanks in advance for your help.
I am trying to convert Chinese database from 5.0 to 2013R2.
I have there a lot of chinese characters which are stored in the db in a different way than the standard characters.
As a first thing i checked how the data looks in the SQL Sever, this is quite big mess.
Data presented in SQL Server is completly different that in the Navision 5.0, some strange characters, but in the Navision 5.0 when I open table everything looks perfect.
Conversion task is done with these steps.
1. Technical conversion to 2009R2 (Chinese characters are still visible when I check in the Navision table, but in the SQL Server I can't see Chinese Characters)
2. Technical conversion to 2013 (I can't check how the data looks like in the Navision, but in the SQL Server is still mess)
3. Technical conversion to 2013R2 (after I imported all necessary objects I was able to connect db to the service and open table) As you can expect data presented in the RTC Navision table is not what I had in 5.0. Chinese characters were replaced with some strange digits, i can see the same "strange" characters like on SQL Server.
Is there any person here who has some expirence with this kind of conversion?
I am looking for some tips how to convert this db from 5.0 to 2013R2 and keep there Chinese characters.
Thanks in advance for your help.
0
Comments
You need to convert your chinese data to unicode. Please take a look
Roberto Blog for more information.
Actually this is what i did. They provide me with some details how I can make it.
During these few days I am going to finish this conversion. Lets check what will happen.
Thank you for your suggestion.