Modify

Opened 6 years ago

Closed 2 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 4 years ago by anonymous

  • Keywords UTF-8 added; utf-8 removed

comment:2 Changed 4 years ago by rjollos

  • Description modified (diff)

comment:3 Changed 2 years ago by codeFiend

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

thank you.

Add Comment

Modify Ticket

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


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

 
Note: See TracTickets for help on using tickets.