List '\' behavior as a bug?

From: Bryan Brunton <bryan(at)flesherfab(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: List '\' behavior as a bug?
Date: 1998-08-13 14:32:03
Message-ID: 316E0AE33DA6D1119E0D00400535C0A301EFBE@zarathustra.flesherfab.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


Is there any chance of recording the '\' storage behavior as a bug? I
don't
know what kind of bug tracking PostgreSQL has.

I view this as a serious problem. The user of a database should have
complete
confidence that whatever is sent to the back-end actually gets stored,
not altered
because of the existence in the data of one type of character.

In my instance it makes storing windows paths such as
\\Xavier\Manufacturing
impossible. I've got lots of other data that could contain backslashes
that I
couldn't afford to have altered. Sorry to sound alarmist, but this
behavior is a
real show stopper for me.

> -----Original Message-----
> From: James Oden [SMTP:joden(at)lee(dot)k12(dot)nc(dot)us]
> Sent: Thursday, August 13, 1998 5:47 AM
> To: Bryan Brunton
> Cc: pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [INTERFACES] '\' and varchar data type problem w/ MS
> Access and ODBC driver
>
>
>
> >
> >The backslash character '\' seems to cause problems when using the
> >varchar
> >data type. MS Access will refuse to update a varchar field if 3
> >backslashes
> >have been inserted.
> If you want litterally three backslashes you may need to massage the
> data to
> add an extra one before each one, so your three back slashes become
> six back
> slashes. I am just guessing on this, but in postgreSQL's
> implementation of
> SQL (and this may be just a SQL thing) the \ is used as an escape
> sequence,
> much like it is in C. Someone else on the list earlier had a problem
> recreating his databases from a dump because it did have \'s in
> it....james
>
>

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1998-08-13 15:14:45 Re: [INTERFACES] '\' and varchar data type problem w/ MS Access a nd ODBC driver
Previous Message James Oden 1998-08-13 11:46:51 Re: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver