[ic] Stupid limits

Daniel Davenport DDavenport at newagedigital.com
Thu Mar 2 07:57:40 EST 2006


> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org 
> [mailto:interchange-users-bounces at icdevgroup.org] On Behalf 
> Of Stefan Hornburg
> Sent: 2006 March 02 -- Thursday 4:48 AM
> To: interchange-users at icdevgroup.org
> Subject: Re: [ic] Stupid limits
> Elver Loho wrote:
> > Hi!
> > 
> > We've been using a flat tab-separated text file for translations so 
> > far. Since we're expanding, we want to move to a database-based 
> > localization system.
> > 
> > There are some problems, however.
> > 
> > Thing is, we created a table for localization in MySQL and 
> populated 
> > it with a mixture of latin1 and utf8-encoded strings from 
> the current 
> > translation system. It had the needed fields. When interchange was 
> > configured to use it, it _completely changed the structure of the 
> > table_...
> > 
> > The code field was limited to 16 characters -- a limitation 
> not part 
> > of the flat text file and which caused some fields to be truncated.
> > Furthermore, it seems that interchange also messed up the character 
> > set encodings of various fields.
> > 
> > So, should we just keep on using the current system? Or is 
> there a fix for this?
> Advise Interchange to keep its hands off this table with "NoImport".

Also, the tables should each have a file describing them in
dbconf/mysql/${table}.mysql.  Those files should have lines that say 
	Database  some_table_name  COLUMN_DEF  "code=char(16)"
or the like.  The default, if no such line describes a column, is to
make the first column (which is assumed to be the key) a char(16), and
any other field a char(128).  You can override that by adding a
COLUMN_DEF line for the field whose structure you care about.

This is more helpful if you ever intend to move the catalog, as IC will
have enough info to rebuild the database at its new home.

Daniel Davenport
New Age Digital

More information about the interchange-users mailing list