info. helpful to boxcar online inventory project consolidated under a single post

http://phpjabber.g-blog.net/HomePage

stunnel local command:
stunnel.exe stunnel.conf

so i was having problems in my python script inserting data into the MySQL database from Access b/c I guess Access uses unicode and python was trying to automagically encode some weird character into latin-1 when doing the insert.

This code shows the problem:

>>> s = u'\u2026'
>>> s.encode('latin-1')
Traceback (most recent call last):
File "", line 1, in ?
UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2026' in position 0: ordinal not in range(256)
>>> s.encode('ascii')
Traceback (most recent call last):
File "", line 1, in ?
UnicodeEncodeError: 'ascii' codec can't encode character u'\u2026' in position 0: ordinal not in range(128)
>>> s.encode('utf-8')
'\xe2\x80\xa6'

this post proved to be a little helpful:

http://mail.python.org/pipermail/python-list/2003-December/200090.html

this document was even more helpful:

http://python.active-venture.com/tut/node5.html

when constructing the DSN be sure to use r”DSNSTRING” because the \b was getting interpretted wrong

mysqldump --no-data

     
      SSLRequireSSL
      
    

this is real helpful in refreshing my memory
http://www.devshed.com/c/a/MySQL/Beginning-MySQL-Tutorial/