Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

insert special char to column Expand / Collapse
Posted Thursday, September 16, 2010 4:49 AM


Group: General Forum Members
Last Login: Friday, May 6, 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'

Post #987087
Posted Thursday, September 16, 2010 4:54 AM



Group: General Forum Members
Last Login: Today @ 9:13 AM
Points: 13,784, Visits: 35,424
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' )
sqlserver → 2005 sqlserver ? 2005


--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 »

Add to briefcase

Permissions Expand / Collapse