Re: AW: Assistance With Embedded SQL

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

BirgittaHauser wrote:
> I'd not use the hex value x'7D' for quotes, because it may not be
> international. 
> Using two single quotes is the better solution.
>   
Actually, this isn't true.  Apostrophe is a member of the invariant 
character set in EBCDIC.  That is, every EBCDIC code set has the 
apostrophe in the same place, x'7D'.  In your other message you 
reference the characters $, # and @ - these are variant characters and 
are definitely not in the same place in different languages.  I dealt 
with this in BPCS; I ran the project that removed variant characters 
from all BPCS source code - it was much more difficult than you might 
imagine!

Anyway, the only time you can get in trouble with x'7D' is when you are 
dealing with ASCII or Unicode.  Apostrophe is definitely not x'7D' 
there; in fact almost no characters have the same hex value in ASCII and 
EBCDIC.  Interestingly, CR (carriage return) does have the same value, 
while LF (linefeed) does not.

Joe