how to read ascii value " þ " from netezza into sas

Reply
Occasional Contributor
Posts: 14

how to read ascii value " þ " from netezza into sas

ho to read ascii value  shown in subject into SAS

Valued Guide
Posts: 3,208

Re: how to read ascii value " þ " from netezza into sas

Dennis, I do not recognize that char  " þ " it looks to be xFE. That is not ascii (7-bit origin) but latin1.
You are possible hit by encoding issues. It would be interesting what the encoding of SAS is the encoding/translation being set at the netezza client and what the encoding is at the netezza site. To have it more complicated not all lantin1 encodings are equal. That is why utf8 is getting that much attention for standardization.

Word Excel and internet (html) are using utf8. But SAS and many RDBMS systems are not using that (by default).    

Some links:

IBM InfoSphere Information Server, Version 8.7 Information Center (netezza)

SAS(R) 9.3 National Language Support (NLS): Reference Guide (overview transcoding)

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 1 reply
  • 355 views
  • 0 likes
  • 2 in conversation