Re: Anybody here know anything about doing SQL Prepared Statementsfrom PHP?

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 09/27/2016
02:47:53 PM:

From: CRPence <crpbottle@xxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 09/27/2016 02:48 PM
Subject: Re: Anybody here know anything about doing SQL Prepared
Statements from PHP?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

On 27-Sep-2016 13:18 -0500, James H. H. Lampert wrote:

[…] given that hex'0A' has been entrenched in the application for
over two decades, changing the application is not an option.

If the code point 0x0A is required to be stored in the EBCDIC
application data [to avoid changing the application], then consider:

That 0x0A is the Repeat (RPT) control character in EBCDIC, into which

the Single Shift Two (SS2) control character should translate from the
code point 0x8E in ASCII.

There is no 0x8E in ASCII. ASCII is 7-bit and has a range of 0x00 to 0x7F.
There are various 8-bit extended ASCII code pages, though (such as
ISO-8859-1). Remember that PHP runs in PASE, which will be using some
8-bit extended ASCII code page or UTF-8 depending on how it was started.
So just be aware that this hack of using 0x8E to conver to EBCDIC 0x0A is
not foolproof or completely portable.