db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Dietz <jo...@purplebear.com>
Subject Re: Schema Datatypes
Date Sat, 24 May 2003 04:35:12 GMT
Wow, that is a really useful file.  Thanks.  I'm not sure I would have 
found that myself.

John Dietz

On Friday, May 23, 2003, at 07:05  PM, Darrell B wrote:

> John D,
> Look under torque-gen-3.1-alpha1\templates\sql\base  then choose the 
> database your using and look for a file called: db.props this file 
> should provide you with the info you're looking for.
>
> John Dietz wrote:
>
>> I suppose in a way I just answered my own question.  If I put in an 
>> invalid type it gives me a list when I try to compile.  Here's the 
>> list:
>> BIT TINYINT SMALLINT INTEGER BIGINT FLOAT REAL NUMERIC DECIMAL CHAR 
>> VARCHAR LONGVARCHAR
>> DATE TIME TIMESTAMP BINARY VARBINARY LONGVARBINARY NULL OTHER 
>> JAVA_OBJECT DISTINCT
>> STRUCT ARRAY BLOB CLOB REF BOOLEANINT BOOLEANCHAR DOUBLE
>>
>> Of course that still doesn't tell me how each maps to the database.
>>
>> John Dietz
>>
>> On Friday, May 23, 2003, at 06:11  PM, John Dietz wrote:
>>
>>> Are the supported datatypes for the schema documented anywhere?
>>>
>>> The schema reference page includes the following for the column 
>>> element:
>>>
>>>  type       What type of column is it? Covered below, defaults to 
>>> VARCHAR
>>>
>>> But as far as I can tell, it's not covered below.  I'm just looking 
>>> for a list and for things like how to define precision for a 
>>> number/decimal column.
>>>
>>> thanks,
>>>
>>> John Dietz
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>
> -- 
> Darrell Bechtel,  B.G.S., MCSE
>
> Systems Manager
> Metokote Corporation of Canada
> 1011 HomerWatson Blvd.
> Kitchener, Ontario
> Ph: (519)669-0559
> Fax:(519)669-3635
> http://www.metokote.com
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


Mime
View raw message