On Wed, 17 Jun 1998 [EMAIL PROTECTED] wrote:
> Is there any way of having an apostrophe in a data field?
> It is a problem because the apostrophe is the same character as the single
> quote, so the database gets a parser error when a name such as "O'Brian"
> is entered.
>
> There must be a work
[EMAIL PROTECTED] writes:
> the escape character brings up the help menu, thinking that \' is not a
> valid option.
No.
Entering something like
SELECT * FROM foo WHERE name=´O\´Brian´;
definitely works.
Ciao
Christoph
--
** http://ourworld.compuserve.com/homepages/ChLorenz/ ** [EMAIL PROTE
Just escape the apostrophe with a backslash.
Byron
[EMAIL PROTECTED] wrote:
> Is there any way of having an apostrophe in a data field?
> It is a problem because the apostrophe is the same character as the single
> quote, so the database gets a parser error when a name such as "O'Brian"
> is en
the escape character brings up the help menu, thinking that \' is not a
valid option.
On Wed, 17 Jun 1998, Brett W. McCoy wrote:
> On Wed, 17 Jun 1998, Amos Hayes wrote:
>
> > > Is there any way of having an apostrophe in a data field?
> > > It is a problem because the apostrophe is the same ch
On Wed, 17 Jun 1998, Amos Hayes wrote:
> > Is there any way of having an apostrophe in a data field?
> > It is a problem because the apostrophe is the same character as the single
> > quote, so the database gets a parser error when a name such as "O'Brian"
> > is entered.
>
> Have you tried dou
On Wed, 17 Jun 1998 [EMAIL PROTECTED] wrote:
> Is there any way of having an apostrophe in a data field?
> It is a problem because the apostrophe is the same character as the single
> quote, so the database gets a parser error when a name such as "O'Brian"
> is entered.
Have you tried doubling
Is there any way of having an apostrophe in a data field?
It is a problem because the apostrophe is the same character as the single
quote, so the database gets a parser error when a name such as "O'Brian"
is entered.
There must be a work-around, but I can not find any solution.
thank you for y
