On 21 Apr 2012, at 6:48pm, Pavel Ivanov <paiva...@gmail.com> wrote: >>>> The type you probably want is TEXT. >>> >>> The rules are such that VARCHAR column also gets TEXT affinity. >> >> I thought it was worth explaining to him what was really going on. Didn't >> want him going through 30 databases changing hundreds of fields to VARCHAR >> when he should be changing them to TEXT. > > If changing all fields either to TEXT or to VARCHAR has the same > result then why bother? What's the difference?
In many SQL engines, VARCHAR without a stated limit is actually VARCHAR(255) or something like that. I didn't want him to be depending on fixed-length behaviour. But yes, the results are the same. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users