Re: [Koha-devel] Dewey bug (119)

[Paul POULAIN]

Chris Cormack a écrit :
> Stephen Hedges wrote:
>
> > Can anyone think of any reason to keep the biblioitems.dewey column as a
> > DOUBLE(8,6) type?  After installing 2.2.3, I still had problems with this
> > bug, so I did:
> > ALTER TABLE biblioitems MODIFY dewey VARCHAR(10)
> > Everything seems to be working fine -- at least I have yet to find any
> > problems created by this change.  Is the dewey column ever part of any
> > numeric functions?  If we make this change to the biblioitems table, can
> > we close this bug?
>
> Yep, lets do that.
>
> Ive made this change to the recent 2.2.x installs ive done, with no ill
> effects thus far. All I suggest is we make it a varchar(50) or something
> a bit larger than 10. But making it a varchar of some point is a lot
> better than have it a double.
>
> Chris
I thought I changed koha.mysql to have dewey being varchar. Seems I was 
wrong.

I changed it in cvs rel_2_2, for 2.2.4.

--
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)