[ic] 001234 eq 1234 in [data] tag

[Grant]

>>> I just noticed that this returns the title of SKU 1234:
>>>
>>> [data table=products key=|001234| field=title]
>>>
>>> Is this inherited from mysql or is it IC behavior?
>>>
>>> - Grant
>>
>>
>> This is especially problematic because the following produces nothing,
>> which is inconsistent with the above:
>>
>> [loop
>> search="fi=products/ml=1/st=db/sf=sku/se=001234/op=eq/nu=0"][loop-data
>> products title][/loop]
>>
>> - Grant
>
>
> Which type is your sku column in products? varchar or int?
>
> Regards
>        Racke

I have this:

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?

- Grant