Re: Literalizing commas in CHARVAR2 text strings

From: Gordon E. Hooker <gordonh_at_acslink.net.au>
Date: 1995/10/01
Message-ID: <44n77b$1u9_at_dingo.cc.uq.oz.au>#1/1


Hagen Finley <hagen_at_violet.berkeley.edu> wrote:

>I am attempting to insert text strings into a table using SQL on the WIN95
>PO7 beta version. The text is from philosophy texts I am researching and,
>unremarkably, the sentences I am attempting to insert include commas.
>Although I may be misinterpreting the problem, but my hunch is the insert is
>failing on the commas within the string which normally indicate a new column
>during insert. Is there a simple method of literalizing commas within the
>string?
>Any other suggestions would be appreciated.

If you are using the INSERT statement single quotes should escape the meaning of a comma. 'Why, are we here'.

-----------------------------\ooOoo/-----------------------------------
Gordon Hooker MACS PCP                                     ,--_|\
25 Clarke Street, Ripley, Queensland, 4306, Australia     /      \ 
gordonh_at_acslink.net.au                                    \_.--._/
mobile: 018883835 phone: 61-7-2889716                           V
-----------------------------------------------------------------------
It is far better to remain silent and appear a fool, than to open ones mouth and remove all doubt... Received on Sun Oct 01 1995 - 00:00:00 CET

Original text of this message