[development] type(N) in MySQL numeric type defs in core schema useless

Stefan Borchert stefan at borchert.cc
Fri Aug 18 09:23:56 UTC 2006

Dries Buytaert schrieb:
> On 18 Aug 2006, at 08:32, Sammy Spets wrote:
>> Given that, why on earth are we even using them? I propose to strip  
>> the
>> (N) declaration from core schema files. It'll provide a much quicker
>> path between MySQL and PostgreSQL declarations.
>> Any complaints about this proposition?
> Is this true for all types, or just of, say, integers or varchars?
See char [1] and binary[2] documentation. The (N) declaration is for 
reserving space in the specified column (for example char(4) stores 'a' 
as 'a   '). Therefore I would support Sammy's proposal to strip the 
unneeded (N) declaration.
> What URL did you get that information from?
I guess he took this one: 

[1] http://dev.mysql.com/doc/refman/4.1/en/char.html
[2] http://dev.mysql.com/doc/refman/4.1/en/binary-varbinary.html

More information about the development mailing list