News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) SQL Server 2008 R2 Chi...

Microsoft Dynamics NAV (Archived)

SQL Server 2008 R2 China (Hong Kong) collation for NAV 2009 R2 W1

(0) Share

Report

Report

Posted on by Roberto Stefanetti

12,998

Hi guys,

I would need some information for a NAV 2009 R2 W1 Chinese (Hong Kong) installation.

I should install a SQL Server 2008 R2 Runtime Edition with SQL Chinese collaction (SQL collaction for Hong Kong in this case).

I would like to understand what is the SQL collaction that usually is used in installations of SQL Server in Hong Kong.

Below is a list of usable collaction i found:

Examples (many collations)

> ...

> Cinese_Hong_Kong_Stroke_90_CI_KS_WS

> Cinese_Hong_Kong_Stroke_90_CI_AS

> Cinese_Hong_Kong_Stroke_90_CI_AS_WS

> Cinese_Hong_Kong_Stroke_90_CS_AIciaosi

> ...

What should I use to have no problems with NAV 2009 R2 W1 ?

Example : “Chinese_Hong_Kong_Stroke_90_CI_AS” ?

Has anyone had any experiences to suggest ?

Thanks for support

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

RE: SQL Server 2008 R2 China (Hong Kong) collation for NAV 2009 R2 W1

hi,

solution suggested from Tectura : "Latin1_General_100_CS_AS"

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 231,432 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans