problem with string in query
i have a simple query taking all fields of one table (informix) and putting them into an empty mysql table.
one of the records will not insert into the mysql table, error message: db2Query: Field " is of an unknown type.
St Mark's Church : James D Clarke Lower Bdg
i suspect it is something to do with the ' and : but can't understand exactly why
there are other longer records that work so it'd not the field length.
there are 1000's of records and this is the only one with a problem. several others have ' and : in but not together
Subject
Written By
Posted
problem with string in query
February 14, 2007 09:09AM
February 14, 2007 02:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.