How to set Torque schema xml file?

[Youngho Cho]

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>

Then I received an below sql file , Footer.java FooterPeer.java and 
FooterMapBuilder.java file.

--------------------------------------------------------------------------
-- FOOTER
--------------------------------------------------------------------------
drop table if exists FOOTER;

CREATE TABLE FOOTER
(
    NAME VARCHAR (255) NOT NULL,
    FOOTER_TEXT VARCHAR (4096),
    FOOTER_IMAGE VARCHAR,
    PRIMARY KEY()
);

My problem is that Torque generates the foot_image field as a String type ( like below 
..) not binary data 
How can I set the schema xml file for binary type data and long text data ??

/** This class was autogenerated by GenerateMapBuilder on: Mon Jan 08 18:53:24 JST 
2001 */
public class Footer extends BaseObject
{
    /** the value for the name field */
    private String name;
    /** the value for the footer_text field */
    private String footer_text;
    /** the value for the footer_image field */
    private String footer_image;


Thanks 

youngho
�˛���m�n���z���p��"�h��(�:.�˛���m�n���z�ߖ+-Š�x��d�j�!��i��0�f���܆+�r����ۊw��X��
+�)�v�,r��>��鬎��"�h��(