[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