Hi Jason,
Thanks !
That is what I looking for.
Thanks again.
youngho
----- Original Message -----
From: Jason van Zyl <[EMAIL PROTECTED]>
To: Turbine <[EMAIL PROTECTED]>
Sent: Tuesday, January 09, 2001 12:04 AM
Subject: Re: How to set Torque schema xml file?
>
>
> 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]
¢Ë�±Êâmën¸§z�å�Ëp¢¹"�h�Ç(�:.�Ë�±Êâmën¸§z�ß�+-Â�ä�x ¢ ¢d�j·!�Ûiÿü0Âf¢�ªÜ�+Þr�¿¶êÛ�w¸ÒX¬·
+�)àv�,r�¿>º�é¬��ð¢¹"�h�Ç(
