Inserting Symbols into Fields (like ?)

I am attempting to insert a trademark symbol? into a database field but it is not working. Does anyone have any ideas on how to do this properly?

Any help would be very appreciated.

Since the Symbol ? is Ascii charater it should insert on Both Varchar & Nvarchar fields properly. The equalent to the symbol ? is char(153)

|||

insert mytable
(col1)
values
(char(153))