After changing encoding to utf 8 from latin1 , Issue with registering tables in SMC

keerthi78890976 — Fri, 28 Jun 2019 11:00:11 GMT

Hi All,

After changing encoding to utf 8 from latin1 in sas , we are facing issue with registering tables in SMC. There are spaces showing up in table names. Below is the error when trying to register tables with spaces in table names.

NOTE: The autoexec file, /sas/sasconfig/Lev1/SASApp1/WorkspaceServer/autoexec.sas, was executed at server initialization.
1 LIBNAME srcch1_1 ODBC READ_LOCK_TYPE=NOLOCK READBUFF=1000 DATAsrc=xxx SCHEMA=dbo USER=xxx
1 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
NOTE: Libref SRCCH1_1 was successfully assigned as follows:
Engine: ODBC
Physical Name: xxx
2
2 The SAS System Friday, June 28, 2019 06:48:00 AM

NOTE: 34 table(s) not displayed/returned because the name is too long.
3 proc metalib;
4 omr (LIBURI="A5MSZA1O.BA0000SW" / project_reposid = "A5MSZA1O" );
5 REPORT(type = summary out = "tab_info");
6 SELECT ("A

End of log.

Re: After changing encoding to utf 8 from latin1 , Issue with registering tables in SMC

keerthi78890976 — Fri, 28 Jun 2019 15:57:23 GMT

This issue is fixed, added following option in sasenv_local file : export EASYSOFT_UNICODE=YES;

topic After changing encoding to utf 8 from latin1 , Issue with registering tables in SMC in Administration and Deployment

After changing encoding to utf 8 from latin1 , Issue with registering tables in SMC

Re: After changing encoding to utf 8 from latin1 , Issue with registering tables in SMC