Hi all, We've tried many solutions here but are encountering a problem still. I am opening an ODBC to a Postgres DB like this: libname sql_read odbc dsn=OC64 schema=my_schema; And it works, but the problem is the database is encoded with UTF-8, and some columns with unicode characters get translated over to SAS as non-unicode characters. For example, ≥ gets turned into "=". We've tested the exact same driver and ODBC in Python, and this problem doesn't exist, i.e. it is not mis-translating the data. So that suggests the problem is not with the driver or ODBC. Some other things we've tried are: 1. Ensuring the SAS session encoding is UTF-8. (Verifying this by doing a datalines with UTF-8 characters, which are correctly read) 2. Ensuring the column read into SAS has enough characters (it is character type and length 1024) 3. Trying to use the "correctencoding" argument, e.g. proc datasets library=perm nodetails nolist; modify my_table/ correctencoding='utf8'; quit; 4. Trying to use the "outencoding" argument on the library, e.g. libname perm "my_path" outencoding='UTF-8'; 5. Trying to use a PROC SQL odbc passthrough instead of the libname statement (same result). Thank you for any help.
... View more