special characters in sql

Wed, 26 Oct 2005 00:03:15 -0700

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

Re: special characters in sql

Fri, 11 Nov 2005 00:34:36 -0700

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

'special characters in sql' Thread RSS Feed

special characters in sql

Re: special characters in sql