Home » Infrastructure » Windows » sql problem
sql problem [message #99585] Thu, 17 January 2002 00:57 Go to next message
vikas kumar
Messages: 1
Registered: January 2002
Junior Member
hello freind,
i have a problem in insering a data with single quotes in a varchar data type column ina table.
for eg-:suppose there is a table with following specification-;
table a
column msg varchar(20)
now i have to insert this data
vikas's
if i write insert statement like this
insert into a values('vikas's');
it gives a error and data is not inserted.
so,will you please tell me how to write the insert statement.
waiting for your reply.
vikas
Re: sql problem [message #99588 is a reply to message #99585] Fri, 18 January 2002 11:56 Go to previous message
-sven
Messages: 11
Registered: August 2000
Junior Member
Try using two single quote marks to represent the single quote mark within the quoted string, as in:

'vika''s'

I hope this helps.
Previous Topic: Oracle 7.3 or 8i (which one is best suited for Web Dev)
Next Topic: Re: Installing Oracle on Windows 2000 m/c with Pentium 4 processor
Goto Forum:
  


Current Time: Sun Feb 25 22:38:22 CST 2024