Changes between Initial Version and Version 1 of Ticket #6411
- Timestamp:
- Apr 4, 2013, 3:58:51 AM (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #6411
-
Property
Status
changed from
new
toclosed
-
Property
Resolution
changed from
to
wontfix
-
Property
Status
changed from
-
Ticket #6411 – Description
initial v1 1 {{{ 2 #!sh 1 3 [root@ptmon 0.11]# python sqlite2mysql -e /my/path/to/trac -p 'mysql://user:password@localhost/trac' 2 4 Traceback (most recent call last): … … 17 19 File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 203, in unicode_literal 18 20 UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2019' in position 475: ordinal not in range(256) 21 }}} 19 22 20 23 Using innodb, and I've done: 24 {{{ 21 25 ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 26 }}} 22 27 23 Running show create table <table>; on all the tables shows the DEFAULT CHARSET=utf8 and COLLATE=utf8_binon everything.28 Running show create table <table>; on all the tables shows the `DEFAULT CHARSET=utf8` and `COLLATE=utf8_bin` on everything. 24 29 25 30 Not exactly sure what I'm doing wrong here.