Doctrine 2 - ORM

Table collate/charset doesn't inherits from database

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 2.3
  • Fix Version/s: None
  • Component/s: ORM, Tools
  • Security Level: All
  • Environment:
    Symfony2

Description

Using symfony2 command doctrine:schema:create the tables and Varchar fields are Collate/Charset are not inherited from database. I changed MySQL defaults to latin1/latin1_general_ci; The doctrine:database:create works; but tables and fields don't. So I found there is a code on MySqlPlataform.php:

if ( ! isset($options['charset']))

{ $options['charset'] = 'utf8'; }

if ( ! isset($options['collate']))

{ $options['collate'] = 'utf8_unicode_ci'; }

$query .= 'DEFAULT CHARACTER SET ' . $options['charset'];
$query .= ' COLLATE ' . $options['collate'];

So if you don't pass collate and charset as entity options, it will put utf8 and utf8_unicode_ci instead of dabatase default charset.

My suggestion is to change a little bit to:

if (isset($options['charset']))

{ $query .= 'DEFAULT CHARACTER SET ' . $options['charset']; }

if (isset($options['collate']))

{ $query .= ' COLLATE ' . $options['collate']; }

Activity

Ascending order - Click to sort in descending order
William Knak made changes -
Field Original Value New Value
Labels charset, collate, collation, mysql utf, utf8 charset collate collation mysql utf utf8
Benjamin Eberlei made changes -
Status Open [ 1 ] Resolved [ 5 ]
Resolution Won't Fix [ 2 ]

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    William Knak
Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: