How to Convert varchar to nvarchar data with TSQL? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to Convert varchar to nvarchar data with TSQL?

Author

Topic

phrankbooth
Posting Yak Master

162 Posts

Posted - 2009-08-17 : 16:09:04

Hi,

I have a column of varchar data where there are characters in foreign language stored as varchar (raw). I would like to convert those and insert into a new table as nvarchar (the actual characters.)

I have not found a way to do that with TSQL, is it possible?

Thanks!!

--PhB

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-17 : 17:25:30

Do you have some examples?

N 56°04'39.26"
E 12°55'05.63"

phrankbooth
Posting Yak Master

162 Posts

Posted - 2009-08-17 : 18:52:19

Sure here's two:

Loginï¼ˆå…¥å�£ï¼‰

å…¥å�£

Thanks!

--PhB

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-17 : 19:04:22

I meant in this format, so that we can work on it.

declare @sample table (data varchar(20))

insert @sample 
select 'å�£ï¼‰'

And then also post your expected output.

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources