Non-Unicode Charchter NAV 09 R2 Database Migration to Business Central On-Prime

(0) Share

Report

Posted on by Nilesh Gajjar

135

Hello Experts,

We are doing migration of one big Chinese company database from Nav 09R2 to Business Central on-Prime.

They have enter non unicode Chinese language data in master and transaction table in NAV 09 R2 version.

Now when we do the data upgrade to business central. It has not convert non unicode Chinese characters properly in Business Central Unicode value.

Old non unicode data not showing proper in business central.

Can you please guide me is there any way to migrate this old data properly in business central

NAV 2009 R2 - Snapshot - Non-Unicode Chines language value enter in data

While convert this database in BC 14 version

Non-Unicode value not convert properly here

5238.BC.png

We are stuck in this upgrade task. Please help us urgently.

Thank you in advance for replying....

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

YUN ZHU 92,578 Super User 2025 Season 2 on at

Like (0)

Report

RE: Non-Unicode Charchter NAV 09 R2 Database Migration to Business Central On-Prime

Hi, Is this directly converting the old database to Business Central? Please set your language for non-Unicode programs in Region to Chinese, then test it again.

I know this may be troublesome, but if there is not much data in old database, I think you can try to import and export part of data using Configuration Package.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Manuel_SPA 10 on at

Like (0)

Report

RE: Non-Unicode Charchter NAV 09 R2 Database Migration to Business Central On-Prime

Hi Zhu,

We are having same problem. We have already switched Regional settings to Chinesse but data characters of fields are not converted with BC20. Shall we do migration from 2009 again with new regional settings? Do you have any suggestions?

Thanks in advance

Manue

l

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,578 Super User 2025 Season 2 on at

Like (0)

Report

RE: Non-Unicode Charchter NAV 09 R2 Database Migration to Business Central On-Prime

Hi, It seems that you did not switch to the correct region during the migration, the characters are garbled after the migration, so I think there is no way, and it may need to do migration again.

But if there are only a few fields, I recommend using the Configuration Package to import this data.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Manuel_SPA 10 on at

Like (0)

Report

RE: Non-Unicode Charchter NAV 09 R2 Database Migration to Business Central On-Prime

Hi Again. Sorry for delay but I couldn't answer before and I tried to finish process.

Bad news. If I change regional language I upgrade until NAV2015, where I get following error

So, for that step I changed again to spanish, convert and change to chinese. But when I open BC20 characters have been not converted.

Therefore, we will have to do it with rapid start, charging again master data and populate to historical tables.

Thanks for your hekp Zhu!!

Was this reply helpful? Yes No
Suggested answer

Nilesh Gajjar 135 on at

Like (1)

Report

RE: Non-Unicode Charchter NAV 09 R2 Database Migration to Business Central On-Prime

Finally we found the solution using external DLL of (Jet.DataManager.Functions.dll)

We have create SP using DLL by change encoding method we are able to convert it

========

-- Configure the server for CLR operation

sp_configure 'clr enabled', 1

GO

reconfigure

GO

EXEC sp_configure 'show advanced options', 1;

RECONFIGURE;

EXEC sp_configure 'clr strict security', 0;

RECONFIGURE;

-- Import CLR assembly

CREATE ASSEMBLY [Jet.DataManager.Functions]

FROM 'P:\nilesh\Jet Data Manager Server\Jet.DataManager.Functions.dll'

WITH PERMISSION_SET = SAFE

GO

-- Create function from assembly

CREATE FUNCTION [dbo].[ChangeEncoding] (@Input nvarchar(4000), @SourceCodePage int, @TargetCodePage int)

RETURNS nvarchar(4000)

AS EXTERNAL NAME [Jet.DataManager.Functions].[Jet.DataManager.Functions.UserDefinedFunctions].[ChangeEncoding];

GO

=============

UPDATE [dbo].[XXX-Shanghai$Payment Terms]

SET

[Description] = [dbo].[ChangeEncoding]([Description], 850, 936)

Where [dbo].[ChangeEncoding]([Description], 850, 936) NOT LIKE '%??%'

GO

==============

Thank you everyone for suggestion and answer

Was this reply helpful? Yes No
Verified answer

Marco Mels on at

Like (0)

Report

RE: Non-Unicode Charchter NAV 09 R2 Database Migration to Business Central On-Prime

Thank you for sharing final answer. Great work!

Was this reply helpful? Yes No