I am having trouble loading decimal data into a database - specifically, my negative numbers are getting truncated, and I can't figure it out.

Here is what my query looks like:

```
> CREATE TABLE IF NOT EXISTS mytable (id INT(12) NOT NULL AUTO_INCREMENT,
                                    mydecimal DECIMAL(13,2),PRIMARY KEY(id));
> LOAD DATA INFILE 'data.dat' INTO TABLE mytable FIELDS TERMINATED BY ';';

```

And the data.dat that I'm loading:

```
;000000019.50 ;
;000000029.50-;
;000000049.50 ;

```

When it completes, giving me a warning that "Data truncated for column 'mydecimal' at row 2." And when I look at the data, it's stored as positive number. Any ideas how to fix this?