Best Practice for References - Memo, Text and Text Long

28 views
Skip to first unread message

shiju01

unread,
Apr 4, 2018, 1:26:38 AM4/4/18
to iDempiere
Hi community

When and where to use Reference  

(http://www.adempiere.com/Application_Dictionary)


 a) Memo                      - Large Text Editor - Character String up to 2000 characters

 b) Text                        -  Character String up to 2000 characters

 c) Text Long                - Text (Long) - Text > 2000 characters

 d) String                     - Character String

What should be the corresponding postgres data types for each of them when defining the table by ddl?

Reply all
Reply to author
Forward
0 new messages