Using Python to synchronize data between Caché and SQL Server

Task Objective: Extract data from Caché and import it into SQL Server.

Problems encountered:

1, Unicodeencodeerror: ' ASCII ' codec can ' t encode characters in ...

When non-ASCII encoding occurs in a program, Python processing often reports such errors. The remediation code is as follows:

stdi,stdo,stde=sys.stdin,sys.stdout,sys.stderrreload (SYS) Sys.stdin,sys.stdout,sys.stderr=Stdi, Stdo,stdesys.setdefaultencoding ('UTF8')

Explanation of the above code can be consulted: http://blog.csdn.net/love_rongrong/article/details/17119261 and http://blog.csdn.net/kxcfzyk/article/ Details/41414247?utm_source=tuicool

2.

Using Python to synchronize data between Caché and SQL Server