>Is there a similar function for Interger field type like that of DTOS() for dates?
>
>Yes, I can use Pad() or Str(), but that would make the index larger. Is there a function to convert the integer (4 byte binary) into an equivelent 4 byte string for multi field indexes?
bintoc()
index on CharacterField + bintoc(IntegerField) tag MyIndex
If you use collation sequences, be sure to use SET COLLATE TO MACHINE (the default) in this case, or else.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)