[Interchange-bugs] [Bug 266] New - products.mysql

[bugzilla-daemon@interchange.redhat.com]

http://developer.akopia.com/bugs/show_bug.cgi?id=266

*** shadow/266	Sun Jul  8 03:13:35 2001
--- shadow/266.tmp.29427	Sun Jul  8 03:13:36 2001
***************
*** 0 ****
--- 1,32 ----
+ Bug#: 266
+ Product: Interchange
+ Version: 4.6.3
+ Platform: PC
+ OS/Version: All
+ Status: NEW   
+ Resolution: 
+ Severity: minor
+ Priority: P5
+ Component: Construct
+ AssignedTo: jon@akopia.com                            
+ ReportedBy: allen_armstrong@canada.com               
+ URL: 
+ Cc: 
+ Summary: products.mysql
+ 
+ When I tried to define a field called date_time or timeanddate as field type of 
+ timestamp. Restarted interchange date_time or timeanddate are being reported as 
+ char(128) (during interchange restart).  Mysql reports the field as varchar
+ (128).  Here is how I define the new field:
+ 
+ Database  products  COLUMN_DEF   "time_date=timestamp"
+ 
+ I also tried:
+ 
+ Database  products  COLUMN_DEF   "time_date=timestamp(14)"
+ 
+ I have updated the products.txt accordingly still no luck.  I will create the 
+ field as timestamp field via mysql.  I am only doing this so that I can use the 
+ mysql odbc connector.
+ 
+ Allen