On Mar 3, 10:22 pm, Hussein B <hubaghd...@gmail.com> wrote: > > > Hey, > > > I added use_unicode and charset keyword params to the connect() method > > > Hey, that was a brilliant idea -- I was just about to ask you to try > > use_unicode=True, charset="utf8" ... what were the actual values that > > you used? > > I didn't supply values for them the first times.
I guessed that! I was referring to the fact that you didn't tell us what values you did eventually supply that made it generate seemingly reasonable Arabic letters in unicode!! Was it charset="utf8" that did the trick? > > > > > Let's suppose that you used charset="XXXX" ... as far as I can tell, > > not being a mysqldb user myself, this means that your data tables and/ > > or your default connection don't use XXXX as an encoding. If so, this > > might be an issue you might like to take up with whoever created the > > database that you are using. > > > > and I got the following: > > > u'\u062f\u062e\u0648\u0644 \u0633\u0631\u064a\u0639 > > > \u0634\u0647\u0631' > > > So characters are getting converted successfully. > > > I guess so -- U+06nn sure are Arabic characters :-) > > > However as suggested above, "converted from what?" might be worth > > pursuing if you like to understand what is going on instead of just > > applying magic recipes ;-) > > > > Well, using the previous recipe for sending the > > > mail:http://code.activestate.com/recipes/473810/ > > > I got the following error: > > > > Traceback (most recent call last): > > > File "HtmlMail.py", line 52, in <module> > > > s.sendmail(sender, receiver , msg.as_string()) > > > [big snip] > > > > _handle_text > > > self._fp.write(payload) > > > UnicodeEncodeError: 'ascii' codec can't encode characters in position > > > 115-118: ordinal not in range(128) > > > > Again, any ideas guys? :) > > > That recipe appears to have been written by an ascii bigot for ascii > > bigots :-( > > > Try reading the docs for email.charset (that's the charset module in > > the email package). > > Every thing is working now, I did the following: > t = MIMEText(markup.encode('utf-8'), 'html', 'utf-8') > Thank you all guys and especially you John, I owe you a HUGE bottle of > beer :D Thanks for the kind thought, but beer decreases grey-cell count and increases girth ... I don't need any assistance with those matters :-) Cheers, John -- http://mail.python.org/mailman/listinfo/python-list
