[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:
http://dev.mysql.com/doc/refman/4.1/en/numeric-types.html
[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