On Mar 3, 1:54 pm, John Machin <sjmac...@lexicon.net> wrote: > 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? > > > > > Yes, it is utf8
> > > 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 No problem John. -- http://mail.python.org/mailman/listinfo/python-list
