SQL collation

KisuKisu Posts: 512Member
edited 2011-09-20 in SQL General
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.


Sign In or Register to comment.