On Mon, 8 Jan 2001, Youngho Cho wrote:
> Hi,
>
> I would like to generate sql , peer and map file using torque (including in
>tdk-1.1a10) for
> binary Image data and long text data for MySQL.
>
> if I set the schema xml file like
>
> <app-data>
> <database>
> <table name="FOOTER">
> <column name="NAME" required="true" size="255" type="VARCHAR"/>
> <column name="FOOTER_TEXT" size="4096" type="TEXT"/>
> <column name="FOOTER_IMAGE" type="BLOB"/>
> </table>
> </database>
> </app-data>
>
The type that you specify is the JDBC in the torque file, this
type is mapped by the db.props file for your target database.
For MySQL this db.props file would be located in
$TORQUE_HOME/templates/sql/base/mysql/db.props
For the type 'BLOB' there is probably no mapping to the
native type so you are getting VARCHAR as the default.
What's the target DB? I think there are currently mappings
for the type 'VARBINARY' which maps to MEDIUM_BLOB in MySQL.
You simply have to change the mapping of JDBC type -> Native type
in the db.props file.
jvz.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
