BookmarkSubscribeRSS Feed

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

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

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Article Labels
Article Tags