[development] Form field maxlengths vs. database field sizes

Piotr Krukowiecki piotr at mallorn.ii.uj.edu.pl
Sun Feb 12 08:40:52 UTC 2006


On Sun, Feb 12, 2006 at 01:43:57PM +0530, Karthik wrote:
> How about pgSQL?

Postgres counts in characters.


[Sidenote]
Furthermore, there's no difference in performance between
char/varchar/text and I've changed several columns from varchar(n) to
text in cases where data was of unknown lenght (e.g. referrer, url etc).

I've left other columns unchanged because I didn't want to drift away
from mysql version too much, but I'd prefer to change (almost) all 
columns for user-supplied data (e.g. node title comes to mind) to
unlimited lenght... I don't see why we should limit user and say how
long his title can be.


-- 
Piotrek
irc: #debian.pl
Mors Drosophilis melanogastribus!


More information about the development mailing list