Good Afternoon, I'm writing a program that is essentially connecting to MS SQL Server and dumping all the contents of the tables to separate csv's. I'm almost complete, but now I'm running into a Unicode issue and I'm not sure how to resolve it.
I have a ridiculous amount of tables but I managed to figure out it was my Contact and a contact named Robert Bock. Here's what I caught. (127, None, u'Robert', None, u'B\xf6ck', 'uCompany Name', None, 1, 0, 327, 0) The u'B\xf6ck' is actually Böck. Notice the ö My problem is I'm not really sure how to handle it and whether or not it's failing on the query or the insert to the csv. The Exception is: 'ascii' codec can't encode character u'\xf6' in position 1: ordinal not in range(128) Thanks Tony
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor
