Changes between Initial Version and Version 2 of Ticket #4030


Ignore:
Timestamp:
Jan 21, 2011 12:32:20 AM (4 years ago)
Author:
rjollos
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