THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
- Miscellaneous
- OFBiz's Data File Tools Some tips from Jacopo
- How to use EntityWhereString A tip from GrimTim
- How to troubleshoot SQL errors A tip from Chris Lombardi
- Tips for View Entities A tip from SkipDever
- How to connect to an External Database A tip from Adrian Crum
- How to save customised data for import as demo data A tip from Raj Saini
- Is it possible to delete products, categories, catalogs, etc., that are no longer needed?
- About lastUpdatedStamp, lastUpdatedTxStamp (transaction), createdStamp, and createdTxStamp
- Why primary keys are VAR_CHAR type in OFBiz ? A tip from David E. Jones
- MySQL
- Oracle
...
From a discussion between Jacopo and Hans on dev ML
Anchor | ||||
---|---|---|---|---|
|
Why primary keys are VAR_CHAR type in OFBiz
- The performance overhead is minimal on modern database systems.
- Character strings give significant flexibility, especially when it is common to migrate data from other systems that have characters in their IDs.
- Being able to prefix IDs is used in a number of places in OFBiz, including prefixes for entire systems when data transfers between them are done to separate ID spaces.