Replacing a control character in a string
Posted: Thu Nov 13, 2003 6:18 am
> -----Original Message-----
> From: Mark Ewart-Phipps [mailto:mark@centerfieldsoftware.co.za]
> Sent: Thursday, November 13, 2003 11:43
> To: datastage-users@oliver.com
> Subject: RE: Replacing a control character in a string
>
>
> Thanks Len, 253 removed the y-acute. When I browsed the file
> in DS, I saw a
> u-umlaut attached to the string. I then had a look at the
> ASCII extended
> chart and saw 129 as the u-umlaut decimal value (see
> http://www.asciitable.com/) Maybe I'm getting confused with
> ANSI and ASCII.
> The DataStage help however talks about ASCII.
Aha - when that page says about "Extended ASCII code" that "The most popular
is presented below", I think it's showing you the (US-variant) DOS code page
from pre-Windows days. That's where all the block-graphics characters for
drawing boxes etc. come from. What you're really using in DS by default is
Windows code page 1252, or, really, whatever the code page of your Windows
client is set to. The help should really only talk about ASCII up to
char(127) because beyond that point there isn't really an ASCII standard.
Cheers........Len
> From: Mark Ewart-Phipps [mailto:mark@centerfieldsoftware.co.za]
> Sent: Thursday, November 13, 2003 11:43
> To: datastage-users@oliver.com
> Subject: RE: Replacing a control character in a string
>
>
> Thanks Len, 253 removed the y-acute. When I browsed the file
> in DS, I saw a
> u-umlaut attached to the string. I then had a look at the
> ASCII extended
> chart and saw 129 as the u-umlaut decimal value (see
> http://www.asciitable.com/) Maybe I'm getting confused with
> ANSI and ASCII.
> The DataStage help however talks about ASCII.
Aha - when that page says about "Extended ASCII code" that "The most popular
is presented below", I think it's showing you the (US-variant) DOS code page
from pre-Windows days. That's where all the block-graphics characters for
drawing boxes etc. come from. What you're really using in DS by default is
Windows code page 1252, or, really, whatever the code page of your Windows
client is set to. The help should really only talk about ASCII up to
char(127) because beyond that point there isn't really an ASCII standard.
Cheers........Len