- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I have a sas stored procedure where the encoding ends up as western-1252. I would like the encoding to be utf-8. As far as I can STP's as setup to use utf-8.
Any idea of how to for
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The solution was to use nvarchar/nchar instead og varchar/char
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Create Unicode Application Server Context
https://go.documentation.sas.com/doc/en/bicdc/9.4/biasag/n10001intelplatform00srvradm.htm#p0x4ziblwb...
Greg Wootton | Principal Systems Technical Support Engineer
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I already have a unicode server context. My problem is that the output from the sql server is not unicode.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
First and foremost, you'll need to ensure you are running SAS with the correct encoding, then have a look at this SAS 9.4 link Multilingual Computing with SAS® 9.4, it has a section on SAS/ACCESS products and how to ensure proper encoding is preserved/used when extracting data from RDBMS
*If you are not using SAS 9.4, you'll need to search the equivalent document for your SAS release.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
oks like your stored procedure is getting data from sql server and the encoding of the data is different.
In addition to what @AhmedAl_Attar has said, have a look at the following from sas documentation
https://documentation.sas.com/doc/en/vdmmlcdc/8.1/nlsref/n0kzmrsdx5evkxn1ihs24h8ljg2b.htm
This should help you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The solution was to use nvarchar/nchar instead og varchar/char