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
Author
Message
Posted Thursday, September 16, 2010 4:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

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'

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:30 AM
Points: 12,927, Visits: 32,325
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 »

Add to briefcase

Permissions Expand / Collapse