title: Django Char vs. Varchar
body: <p>Please Help, I have an existing database that uses a char(12) as its PK.</p>
  
  <p>CREATE TABLE <code>sop_customer</code> (
    <code>customer_id</code> char(12) NOT NULL,
    PRIMARY KEY (<code>customer_id</code>),
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;</p>
  
  <p>I then create a Django Model and create a model based on inspectdb (awesome tool :-))</p>
  
  <p>The problem is when I create another table with a foreign key to this table, the new table will use varchar() and MySQL at the database level will not honour the relationship because of the different types (char vs .varchar) HELP!</p>
  
  <p>I am in the process of trying:
      1 - Update the existing db to Varchar (seems like a rather extreme operation just to get this thing to work :-0)
      2 - Get Django's foreign Key class to recognise the type properly (I understand ORM agnostisism etc).
      2 - Force Django to create a char field and then add the constraint after in Django, although I cant see how this could be achieved without heavy lifting
      3 - Not use Django</p>
  
  <p>Help!</p>