Sql symbol insert?

[sandupas]

Hy !<br />
i have a problem with an insert in a mssql database.<br />
I make an insert in a varchar column with samo texts but in some cases I have the symbol ? in that text and the database doesnt recognise that and it returs ??? <br />
what should I do ?<br />

 

[zephyrwind]

Assuming you're going to be displaying this as html, you could escape the character to its html escape form, which is ø and store that in your database.

Most programming languages have a function that will do this for you... in PHP it's htmlentities().

 

[JasonL]

This ? symbol seem unicode please
1. Change field to nvarchar.
2. If you are using Query Analyzer pleace change encode to unicode then you will see the code.