http://trac.symfony-project.org/trac/ticket/2088

Hi,

I have the following table,

building:
  id:
  abbreviation: { type: varchar(5), required: true }
  name: varchar(63)
  order_no: integer
  note: longvarchar

And here is the fixtures file, and how I loaded it:

$ cat data/fixtures/fixtures.01.building.yml
Building:
  1
    abbreviation: A
    name: Alberta
    order_no: 10
  7
    abbreviation: N
    name: Newfoundland
    order_no: 70
  9
    abbreviation: ON
    name: Ontario
    order_no: 90
  10
    abbreviation: T
    name: Terraces
    order_no: 100
  12
    abbreviation: SK
    name: Saskatchewan
    order_no: 120

$ symfony propel-load-data management data/fixtures/fixtures.01.building.yml
>> propel    load data from "data/fixtures/fixtures.01.building.yml"

Everything looks to me pretty fine, but the result is not:

Id     Abbreviation     Name    Order no        Note
16     A       Alberta         10
17             Newfoundland    70
18     1       Ontario         90
19     T       Terraces        100
20     SK      Saskatchewan    120

$ symfony -V
symfony version 1.0.0

As you can see, "abbreviation: N" show up as nothing, whereas "abbreviation: ON" show up as "1".

Why is that?