mibuso.com

Microsoft Business Solutions online community
It is currently Thu Jul 31, 2014 1:18 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: SQL collation
PostPosted: Tue Sep 20, 2011 9:25 am 
Offline

Joined: Wed Apr 04, 2007 3:34 pm
Posts: 374
Location: Finland
Country: Finland (fi)
I'm still a bit new with changing collations in databases and I came accross with a problem where I'd need wider character support.

We have a Navision 2009 database which has Windows collation, where collation detail is Afrikaans, Basque, Catalan, Dutch, English, Faeroese, German, Indonesian, Italian, Portuguese

I'd need to have Chinese character support on this same Database so the Navision would support

The 9 Vovels = a,e,i,o,u,y,ä,ö,å
the 20 Consonants = q,w,r,t,p,s,d,f,g,h,j,k,l,z,x,c,v,b,n,m
and the chinese letters ( that chines usually use :mrgreen: )


I know unicode has all characters but I dont know how to change the database to that.
Any helping tip would be nice.

_________________
K.S.


Top
 Profile E-mail  
 
 Post subject: Re: SQL collation
PostPosted: Tue Sep 20, 2011 10:49 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Jul 19, 2005 4:49 pm
Posts: 4175
Location: Olst
Country: Netherlands (nl)
There is a procedure on Partnersource on how to use Chinese characters. It's an ugly one that should only be used if there are no alternatives.

I had a customer once that just wanted Chinese descriptions for printing. We did that outside NAV rather than implementing the Microsoft solution.

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Specialist

Author of the book : Microsoft Dynamics NAV Application Design

MY BLOG : http://markbrummel.wordpress.com


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: