Solved

How do I Reconfigure SQL Server to support double-byte characters?

Posted on 2008-10-13
3
1,076 Views
Last Modified: 2013-11-16
Hi,

I have approx. 100K records in a SQL database (2005) that was originally created for single-byte records. I now need to support double-byte characters for localization purposes, and am not sure how to extract, and recreate the database to support double-byte.

Thank you in advance,
 PM
0
Comment
Question by:PatMelzer
3 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 500 total points
ID: 22711040
You need to change data type from varchar to nvarchar, char to nchar, text to ntext (or better, nvarchar(max) )

You can do it through the SSMS gui or issue a SQL statement like:

Alter Table MyTable Alter Column MyColumn nvarchar(<number of characters>)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Read about achieving the basic levels of HRIS security in the workplace.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question