ash42
3 years agoNew Contributor III
Insert Special character in sql server table
I have a sql server bulk insert snap which have a varchar column in table. and i have a input document to this snap having this data 🙂
"• the ability to take part in daily activities "
when i am inserting this to that column in the table it is inserting as
" ò the ability to take part in daily activities "
so any reason why is this happening ,and any solution if possible so that the “bullet point” character get inserted to that particular column.
ps: I am able to insert that data manually in to the table
Any help appreciated