BookmarkSubscribeRSS Feed

[SAS 활용 FAQ] Viya에서 MySQL DB의 data를 읽어오면 한글이 깨져서 보입니다.

Started ‎10-14-2021 by
Modified ‎10-14-2021 by
Views 237

SAS libname 구문에 dbconinit="set names 'utf8';" 옵션을 추가해 보시기 바랍니다.

 

[예제]

libname dblib MySQL user='xxxxx' dbconinit="set names 'utf8';" password='xxxxx' host='xxx.xxx.xxx.xxx' database='xxxx' port=xxxx ;

Version history
Last update:
‎10-14-2021 06:02 AM
Updated by:
Contributors

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Article Labels
Article Tags