Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : dkxhJdjqGt/xV7es1z0bGP
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV, Traditional Chine...
Microsoft Dynamics NAV (Archived)

NAV, Traditional Chinese language support in a non-unicode database sql

Like (0) ShareShare
ReportReport
Posted on 12 May 2013 04:39:05 by Roberto Stefanetti 12,998

Good morning

I have a database that I would like to upgrade from NAV 5 to NAV2013, currently the collaction is 'latin general', without unicode support (it's an very old database)

A brief should enable a communication channel e-commerce platform that gives orders in Navision e-commerce, these orders using the Traditional Chinese language with their own characters (ideograms etc.).

What can I do to correctly handle these characters in Nav ? (now I can not see them in NAV)?

1) Convert the db by switching to unicode (there might be potential problems of space, performance problems etc.).

2) Leave the db as it is and create sql function (or stored procedures) or use. NET to handle the character mapping (Nav then enter the converts from ideograms)

3) Create a new unicode db and execute a data migration

There are other possibilities or advice on this subject?

I would like to implement the best solution

Thanks for support

*This post is locked for comments

  • Verified answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on 26 May 2013 at 21:47:04
    RE: NAV, Traditional Chinese language support in a non-unicode database sql

    Hi Roberto,

    Have you tried our solution? Your feedback is appreciated. Please email to us if any 4BzSoftware@gmail.com.

    We built it on NAV 2013 only because NAV 2013 supports Unicode Data Input.

    Best regards,

    4BzSoftware.

  • Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on 16 May 2013 at 12:43:37
    RE: NAV, Traditional Chinese language support in a non-unicode database sql

    Hi, thanks for support.

    i will try it soon.

    Only for NAV 2013 or any chance for NAV 2009?

    Thanks

  • 4BzSoftware Profile Picture
    4BzSoftware 6,071 on 16 May 2013 at 09:00:03
    RE: NAV, Traditional Chinese language support in a non-unicode database sql

    Hello,

    We got solution for Navision 2013 Table Fields Unicode Caption.

    You can try it with Cronus demo company at my SkyDrive link

    skydrive.live.com/redir

    Hope information can help you!

    Best regards,

    4BzSoftware.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,748 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans