Re: [Web-erp-developers] Re: Postgres

[Phil D. <ph...@du...>]

I fixed these 2 - thanks
Phil

On Thursday 25 March 2004 21:24, Danie Brink wrote:
> 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...
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers