insert special char to column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » insert special char to column

insert special char to column

Rate Topic

Display Mode

Topic Options

Author

Message

DBA_1276

Posted Thursday, September 16, 2010 4:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 06, 2011 12:54 AM
Points: 158, Visits: 151

Hi all,

I am inserting column value as 'sqlserver → 2005' But, it is inserted as 'sqlserver ? 2005'

Pls give the solution to insert Like 'sqlserver → 2005'

Thank'q

Post #987087

Lowell

Posted Thursday, September 16, 2010 4:54 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:22 PM
Points: 11,789, Visits: 28,063

you'll need to change the definition of the column from varchar to nvarchar.
the issue can be seen in this example...special charcters get converted to question marks if a varchar field (or a sloppy insert that implicitly converts it as a varchar)

select convert(nvarchar(30),N'sqlserver → 2005' ),
       convert(varchar(30),N'sqlserver → 2005' )
--results
/*
sqlserver → 2005	sqlserver ? 2005
*/

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #987096

« Prev Topic | Next Topic »

Permissions