1) SQL Server is on Windows Server OS (not sure which) 2) I am using a local EG client connected to a SAS Server (probably Unix, not sure) 3) I am using libraries. For SQL Server I use this code: libname sqllib oledb
datasource = SQLSERVERNAME provider=sqloledb schema='dbo' properties=('initial catalog'=MYDBNAME)
user=user password=password
READBUFF=30000 INSERTBUFF=30000
encoding="utf-8"; 4) When I look at log - I do see ENCODING=UTF8 I think it has smth. to do with nvarchart data types. In SQL Server itself (without SAS) if I insert a value with hebrew characters with regular quotations - then I get question marks. But if i put N'' before quotations - then it is OK. So, how do I make SAS write to SQL Server with N''? Thank you!
... View more