special characters in sql - Programmers Heaven

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

JosePitaJosePita Posts: 16Member
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: 32Member
    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.