How to retrieve unicode data stored directly in non-unicode field as varchar format in sql server -

i have create c# application displays unicode data in textbox.

but sql server column storage has varchar data contains unicode data. since varchar non-unicode based displays character strings "????????".

well problem facing cant change column type there other dependent application running on it.

you cannot store unicode data in varchar without conversion column's collation. so, unicode encoded entirely different when stored in varchar column , lost. if seeing ????? means encoding not find character maps ansi value when being stored , stored question mark instead. if want store unicode in database right solution change column's data type. if cannot change column's data type, add column set nvarchar , ensure unicode sources read , write column.