Opened 8 years ago

Closed 5 years ago

#4030 closed defect (fixed)

better solution for ensuring utf-8 consistancy with

Reported by: bodepd@… Owned by: codeFiend
Priority: normal Component: MantisImportScript
Severity: normal Keywords: UTF-8 mysql unicode use_unicode
Cc: Trac Release: 0.10

Description (last modified by rjollos)

I am no db expert, but I found that I had to change the following to get unicode characters to display and be entered correctly:

    mysql_con = MySQLdb.connect(host=_host,
                user=_user, passwd=_password, db=_db, compress=1,
                cursorclass=MySQLdb.cursors.DictCursor, use_unicode=1)

use_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.

Attachments (0)

Change History (3)

comment:1 Changed 6 years ago by anonymous

  • Keywords UTF-8 added; utf-8 removed

comment:2 Changed 6 years ago by rjollos

  • Description modified (diff)

comment:3 Changed 5 years ago by codeFiend

  • Resolution set to fixed
  • Status changed from new to closed

thank you.

Add Comment

Modify Ticket

as closed The owner will remain codeFiend.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.