Geek Answers Handbook

Change encoding (mapping?) SQL Server 2008 R2 to UTF-8

We would like to migrate our Confluence system to SQL Server 2008 R2. Now, since Confluence uses UTF-8 encoding, I need a database using the same encoding (do I think sorting?).

There team

alter database confluence set collation COLLATION_NAME

Now, it seems there is no utf-8, and as I found out, SQL Server uses ucs-2, which is basically the same. But I can not understand what is the sorting name ucs-2? Does anyone know about this?

Edit: now I see the difference between encoding and sorting. The Confluence documentation suggests that I should create a schema that relies on UCS-2 (since MS SQL lacks UTF-8 support). I looked through Managment Studio and I found an entry for schemas in the Database Security directory. However, I cannot figure out how to assign the UCS-2 encoding to the circuit. What do I need to implement in Managment Studio for this (or what request should I use)?

+6
source share
1 answer

According to the merge documentation, you should set the mapping to SQL_Latin1_General_CP1_CS_AS

We followed this document and had a successful merge deployment on SQL Server 2008 R2:

Database setup for SQL Server

+4
source

More articles:


All Articles