[ic] Upgrading to SQL Database

[interchange-users@icdevgroup.org (Barry Treahy, Jr.)]

Jeff Dafoe wrote:

  >>That would make a nice little FAQ addition.  For me, I just add 
"MYSQL 1"
  >>and "SQL_DSN ..." variables to my configuration, restart, and IC 
does all
  >>the rest.  Some people have more trouble, so it would be nice for 
someone
  >>to write up a neat little FAQ on it (any takers?).
  >>
  >>
  >
  >    I have a theory as to why it is problematic sometimes, at least for
  >postgresql, but I am not certain that I am correct.  It looks like the
  >structures in dbconf/pgsql are missing fields that are in some of the
tables
  >that come with the Foundation store.  So when interchange tries to use
this
  >to create tables there are subsequently errors when the attempt to import
  >the corresponding txt files is made.
  >
  >
I'm not sure that this is so much the case as I believe I read that IC
defaults to a CHAR(128) field for each undefined columns.  What kept
biting me in the back side were fields I wanted more control over,
specifically numeric or decimal fields, and that IC (or perhaps mysql)
would choke and die on the load if the field were null which is not a
behavior I found real friendly...

Barry

-- 

Barry Treahy, Jr  *  Midwest Microwave  *  Vice President & CIO

E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028