Hi:
I am migrating from a9 to a10.
But I met a problem why using Torque:
I have such a table:
<table name="LOCAL_CONTENT">
<column name="ID" primaryKey="true" required="true" type="INTEGER"
autoIncrement="true"/>
<column name="COMPANYID" required="true" type="INTEGER"/>
<column name="CODE" required="true" size="11" type="VARCHAR"/>
<column name="ORENTATION" required="true" size="2" type="VARCHAR"/>
<column name="CONTENT" type="BLOB"/>
<column name="STATUS" size="2" type="VARCHAR"/>
<column name="LAST_MODIFIED" null="false" size="19" type="VARCHAR"/>
</table>
I change db.props to:
BLOB = BLOB
(this has solved a same proble while using a9)
But the generated sql still use VARCHAR for BLOB
CREATE TABLE LOCAL_CONTENT
(
ID INTEGER NOT NULL AUTO_INCREMENT,
COMPANYID INTEGER NOT NULL,
CODE VARCHAR (11) NOT NULL,
ORENTATION VARCHAR (2) NOT NULL,
CONTENT VARCHAR,
STATUS VARCHAR (2),
LAST_MODIFIED VARCHAR (19),
PRIMARY KEY(ID)
);
CONTENT column still use VARCHAR, and since it do not have a length, mysql
will give out a error
Has anybody met this kind of problem also?
Regards
fanyun
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
