Feedback-ID: i76984098:Fastmail
Message-ID: <f414cfd0-b9c4-4a81-a7b6-10af66f2b7e5@aklaver.com>
Date: Mon, 10 Jun 2024 08:38:44 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Escaping single quotes with backslash seems not to work
To: Ron Johnson <ronljohnsonjr@gmail.com>,
 pgsql-general <pgsql-general@postgresql.org>
References: <CANzqJaD0=V+Dh+mLLfLj4ECLHriAH122LiYaqKyAnWCAKCfa6A@mail.gmail.com>
 <CAKFQuwbdAm7=RziKxF+jQki0KXb-quan5fA3sfq8JKoDR3Jumw@mail.gmail.com>
 <CANzqJaCL_p2LmCAUPGUYxOJPN-iOs-JWbpU4ssH+rSw27DmvhA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CANzqJaCL_p2LmCAUPGUYxOJPN-iOs-JWbpU4ssH+rSw27DmvhA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/f414cfd0-b9c4-4a81-a7b6-10af66f2b7e5%40aklaver.com>
Precedence: bulk

On 6/10/24 07:52, Ron Johnson wrote:
> On Mon, Jun 10, 2024 at 10:08 AM David G. Johnston 
> <david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> wrote:

> This hasn't changed from 9.6, has it?
> 
> A Java app that uses backslash escapes broke this morning on fields with 
> single quotes, after the weekend migration from PG 9.6.24 to 14.12, and 
> I don't know why.  I'm not a Java programmer, though.
> 

Was there a change in the JDBC driver also?

-- 
Adrian Klaver
adrian.klaver@aklaver.com