Changes between Initial Version and Version 1 of Ticket #6411


Ignore:
Timestamp:
Apr 4, 2013, 3:58:51 AM (11 years ago)
Author:
Ryan J Ollos
Comment:

This plugin is deprecated. See the TracMigratePlugin.

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #6411

    • Property Status changed from new to closed
    • Property Resolution changed from to wontfix
  • Ticket #6411 – Description

    initial v1  
     1{{{
     2#!sh
    13[root@ptmon 0.11]# python sqlite2mysql -e /my/path/to/trac -p 'mysql://user:password@localhost/trac'
    24Traceback (most recent call last):
     
    1719  File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 203, in unicode_literal
    1820UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2019' in position 475: ordinal not in range(256)
     21}}}
    1922
    2023Using innodb, and I've done:
     24{{{
    2125ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
     26}}}
    2227
    23 Running show create table <table>; on all the tables shows the DEFAULT CHARSET=utf8 and COLLATE=utf8_bin on everything. 
     28Running show create table <table>; on all the tables shows the `DEFAULT CHARSET=utf8` and `COLLATE=utf8_bin` on everything. 
    2429
    2530Not exactly sure what I'm doing wrong here.