Howdy, Stranger!

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

Categories

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

Comments

  • ShanooShanoo Posts: 32
    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.