[ic] 001234 eq 1234 in [data] tag
Peter
peter at pajamian.dhs.org
Tue May 15 01:29:09 UTC 2012
On 15/05/12 00:27, Stefan Hornburg (Racke) wrote:
> On 05/14/2012 01:55 PM, Grant wrote:
>> Database products COLUMN_DEF "sku=INT(6) AUTO_INCREMENT PRIMARY KEY"
>>
>> Am I seeing this behavior because of INT? Is VARCHAR ok to use with
>> AUTO_INCREMENT?
>>
>
> Yes, as the number 001234 is equal to the number 1234. The string
> 001234 is different to 1234. I don't think you can use VARCHAR as
> AUTO_INCREMENT column.
It is possible with postgresql sequences, but not in mysql. I don't
know how IC would react to it, though.
Peter
More information about the interchange-users
mailing list