[ic] Interchange and MySQL

Joshua Lavin joshua at kingdomdesign.com
Tue Nov 18 10:10:56 EST 2003


On Tuesday, November 18, 2003, at 09:46  AM, Jack Gates wrote:

> When I load my products.txt file to MySQL through the IC Admin UI at 
> the
> tables something addeds quotation marks around all the text in the 
> comment
> and size columns. Is this getting done by IC or MySQL? Does any one 
> know how
> to get the files to upload without the quotation marks getting added?
>
> IC 4.8.7
> MySQL 3.23.58
>
> TIA for any help,
>
> Jack Gates

The way we reload our products database is: copy the old products.txt 
to a backup, post the new products.txt, then move products.sql to 
products.oldsql. The database is rebuilt on the next page request. 
There aren't any quote marks, but I haven't tried it another way.

Josh



More information about the interchange-users mailing list