Why primary keys are VAR_CHAR type in OFBiz?

[Dhruv Datta]

Hello Frns,

   I am a *newbie* in OFBiz and was playing with the OFBiz.

  During my play I found that in OFBiz data type for all the primary keys
are VAR-CHAR, but VAR-CHAR data type is not a good practice for the
efficiency perspective because it takes extra time during searching. Can
anyone please tell me why OFBiz uses VAR-CHAR data type used for primary key
instead of NUMERIC data type.

Any help would  be greatly appreciated.


Dhruv.