[Web-erp-developers] Re: Postgres

[Danie B. <br...@na...>]

Hi Phil,

In my testing of queries I have found that the field types used for
referential integrity does not always match. As I have been testing with
postgres as well, I have discovered postgres will not consider
varchar(20) the same as char(20) and varchar(5) the same as char(5) and
type casts are required. This is a correct, however mysql ignores the
difference as it treats char the same as varchar. We should add database
type checking to our to-do list.

Things I have decovered so far.
LocStock.LocCode = PurchOrders.IntoStockLocation = varchar(5)/char(5)
LocStock.StockID = PurchOrderDetails.ItemCode = StockMaster.StockID =
varchar(20)/char(20)

Kind Regards
Danie Brink br...@na...