Re: can INFORMIX insert a '"' (double quote) in a char field?

> > > Can anyone ADD data to a char field in an INFORMIX database that contains > quotes? Let's say you have a table (abc) which has 1 field (a) which is > a char type sizeof 15; can you add the below record? > > > ______ script for loading values ----- ____comments____ > > insert into abc values ("this is a test"); This works > insert into abc values ("this is a 'test'"); This works > insert into abc values ("this is a "test""); This doesn't > insert into abc values ('this is a "test"'); This doesn't > insert into abc values ("this is a \\"test\\""); This doesn't> > As you can see I can get the single quote to work; but, I want the double quote. Bob, I was able to get the fourth statement to load with a minor glitch. The field only takes 15 chars; of course 'this is a "test"' (not including the single quotes is 16 chars, but I got 'this is a "test' (15 chars) worked fine. When I changed the field length to 16 chars the entire text was entered. Platform: Motorola 88K using Informix 4.00.UE2 -- Rory Martin Internet: dksl2vq@bell-atl.com Bell Atlantic Network Services 2221-L Broadbirch Drive Voice: 1+ (301) 989-5075 Silver Spring, MD 20904-1985 "No matter where you go, there you are." ---------------------------------------------------------------------------