Changes between Initial Version and Version 2 of Ticket #4030


Ignore:
Timestamp:
Jan 20, 2011, 11:32:20 PM (13 years ago)
Author:
Ryan J Ollos
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #4030

    • Property Keywords UTF-8 added; utf-8 removed
  • Ticket #4030 – Description

    initial v2  
    11I am no db expert, but I found that I had to change the following to get unicode characters to display and be entered correctly:
    2 
     2{{{
    33    mysql_con = MySQLdb.connect(host=_host,
    44                user=_user, passwd=_password, db=_db, compress=1,
    55                cursorclass=MySQLdb.cursors.DictCursor, use_unicode=1)
    6 
     6}}}
    77use_unicode=1 is the same as set names="utf-8", this ensures that the database data is retrieved in this format. I prob had to do this as a misconfiguration on our DB where everything is set to latin, even thougn german characters are used.
    88