MSSQL, varchar data to nvarchar data

Posted by Øyvind on Stack Overflow See other posts from Stack Overflow or by Øyvind
Published on 2010-05-10T12:19:17Z Indexed on 2010/05/10 12:24 UTC
Read the original article Hit count: 284

Filed under:

varchar

|

nvarchar

I've got a database with collation Danish_Norwegian_CS_AS and lots of varchar columns. I'd like to convert all this data to unicode, but haven't found a way to convert this data yet. If I've understood correctly, the encoding used is UCS-2 little endian.

For example I've got a column containing 'PÃ¥l-Trygve' which is easily converted with C# to 'Pål-Trygve' using Encoding.Default.GetString(Encoding.UTF8.GetBytes("PÃ¥l-Trygve"));

Is there a way to do this conversion in the microsoft SQL client?

© Stack Overflow or respective owner

Related posts about varchar

varchar(255) to varchar(MAX)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to change a column type in a MS SQL 2008 database from varchar(255) to varchar(MAX) without having to drop the table and recreate? SQL Server Management Studio throws me an error every time I try to do it using that - but to save myself a headache would be nice to know if I can change… >>> More
find elements of a varchar in another varchar

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, i have a varchar field with the content like these: a,b,c,d e,d,a,c b,q,d,e i need to do a query that select only the rows with the field that has elements equals with an input string. ex input: c,a rows selected: a,b,c,d e,d,a,c is possible without use the OR (field like '%a%' OR field… >>> More
How to concat datatypes like integers(integer with integer) & varchar(varchar with varchar) in mysql

as seen on Stack Overflow - Search for 'Stack Overflow'
How can we concat integers with integers varchar with varchar int with varchar in MySQL ? >>> More
what's wrong with mysql to create very long table fields?

as seen on Stack Overflow - Search for 'Stack Overflow'
mysql> create table balance_sheet( -> Cash_and_cash_equivalents VARCHAR(20), -> Trading_financial_assets VARCHAR(20), -> Note_receivable VARCHAR(20), -> Account_receivable VARCHAR(20), -> Advance_money VARCHAR(20), -> Interest_receivable VARCHAR(20)… >>> More
Android : SQL Lite insertion or create table issue

as seen on Stack Overflow - Search for 'Stack Overflow'
Team, can anyone please help me to understand what could be the problem in the below snippet of code? It fails after insertion 2 and insertion 3 debug statements I have the contentValues in the Array list, I am iterating the arraylist and inserting the content values in to the database. Log.d("database"… >>> More

Related posts about nvarchar

Convert VARCHAR() columns to NVARCHAR()

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
We recently underwent an upgrade that required us to change our database columns from varchar to NVarchar, to support unicode characters. Digging through the internet, I found a base script which I modified to handle reserved word table names, and maintain the NULL/NotNull constraint of the columns… >>> More
SQL Server 2005 stored procedure error

as seen on Stack Overflow - Search for 'Stack Overflow'
I have created a stored procedure of insert command for employee details in SQL Server 2005 in which one of the parameters is an image for which I have used varbinary as the datatype in the table.. But when I am adding that parameter in the stored procedure I am getting the following error- … >>> More
SubSonic 3 ignoring columns in Select()

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table like so.. CREATE TABLE [dbo].[Locations_Hours]( [LocationID] [int] NOT NULL, [sun_open] [nvarchar](10) NULL, [sun_close] [nvarchar](10) NULL, [mon_open] [nvarchar](10) NULL, [mon_close] [nvarchar](10) NULL, [tue_open] [nvarchar](10) NULL, [tue_close] [nvarchar](10) NULL… >>> More
ASP.NET MVC 2 RC2 Model Binding with NVARCHAR NOT NULL column

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database column defined as NVARCHAR(1000) NOT NULL DEFAULT(N'') - in other words, a non-nullable text column with a default value of blank. I have a model class generated by the Linq-to-SQL Classes designer, which correctly identifies the property as not nullable. I have a TextAreaFor in… >>> More
How to insert a line break in a SQL Server VARCHAR/NVARCHAR string

as seen on Stack Overflow - Search for 'Stack Overflow'
I didn't see any similar questions asked on this topic, and I had to research this for something I'm working on right now. Thought I would post the answer for it in case anyone else had the same question. >>> More