ORA-29275 - partial multibyte character (Analytics Pro)

[terry711]

Hi,

I'm new to SAS Analytics Pro.

Got the following error when reading data from Oracle database.

It seems like the character set between SAS and Oracle DB does not match.

2    Data test;
3    set orapmkt.v_dw_hk_misc_clickthrough;
4    run;

ERROR: Error fetching from cursor. ORACLE error is ORA-29275: partial multibyte character and no result.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 500 observations read from the data set ORAPMKT.V_DW_HK_MISC_CLICKTHROUGH.
WARNING: The data set WORK.TEST may be incomplete.  When this step was stopped there were 500
         observations and 15 variables.

I have searched related documents on web and cannot find some sample script on how to set the character set to UTF-8 in the SAS section when retrieving the data.

Can someone help to answer where to put ENCODING=UTF-8?

Thanks a lot.

[Patrick]

You will find the doc for this area of questions under NLS (national language support).

Not sure if below link is the answer:

http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#n08gwe43ne71imn1oz7...

Try to get support from your SAS Admin at your site for this. It's not really something a SAS "business" user should have to solve on it's own.