special characters in sql

im having trouble storing special characters in my sql table, is it possible to store for example an ' (apostrophe) ? ive tried setting the field in the table to varchar but this doesnt help


  • It is possible to store apostrophe (') in SQL Server tables.
    Try the following:

    Create Table Test
    (ID int Primary Key,
    Data varchar(100))

    Insert Into Test Values (1, 'This is an apostrophe -> ''. Other special characters are: !@#$%^&;*()_+{}[]|/?<>,.')

    Select * From Test

    - HTH
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion