Ok I got a xdoc / html file about this.
I offer someone @ torque to take atachment and put it somewhere on torque site.
Maybe that help, maybe not.


Anyway there is a link : http://www.devaki.org/torque-type-map.html

Regards

Emmanuel Florent
[EMAIL PROTECTED]
http://www.devaki.org/

On 2003.03.31 11:21 CY Ing wrote:
There is a db.props file under the
<torque>\templates\sql\base\<dbname>\db.props that reveals the mapping
between Torque type and database physical type. For example, the one
under
mssql looks like this: (Left-side should be Torque type and right-side
should be database type)

BIT = BIT
TINYINT = TINYINT
SMALLINT = SMALLINT
INTEGER = INT
BIGINT = BIGINT
FLOAT = FLOAT
REAL = REAL
DOUBLE = FLOAT
NUMERIC = NUMERIC
DECIMAL = DECIMAL
CHAR = CHAR
VARCHAR = VARCHAR
LONGVARCHAR = TEXT
DATE = DATETIME
TIME = DATETIME
TIMESTAMP = DATETIME
BINARY = BINARY(7132)
VARBINARY = IMAGE
LONGVARBINARY = IMAGE
NULL = NULL
OTHER =
JAVA_OBJECT =
DISTINCT =
STRUCT =
ARRAY =
BLOB =
CLOB =
REF =


Hope this helps.


-----Original Message-----
From: peter riegersperger [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 5:16 PM
To: Turbine Torque Users List
Subject: Re: torque data type <-> database data type overview


-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

On Monday 31 March 2003 11:06, Joachim M�ller wrote:
> Hi All.
>
> As a newbie to torque I am trying to get a
> description of the data types transformation between
> torque and other databases, especially Oracle.
>
> Unfortunalety the schema reference describes
> the attribute 'type' with:
>
> 'What type of column is it? Covered below, defaults
> to VARCHAR'
>
> but does not cover it below.
>
> The mailing list archive comes up with an error,
> so I cannot search the mailing list.
>
> Maybe I'm just blind. Can somebody open my eyes?

well, probably a little. i also did not find any information about
datatypes.
take a look at database.dtd (inside your torque-directory), there's a
list
of
valid datatypes in it.
i think the mapping is quite straight-forward.

hope that helps,

rick


- -- |- | peter riegersperger <[EMAIL PROTECTED]> |- | subnet | platform for media art and experimental technologies |- | http://www.subnet.at/ |- | muehlbacherhofweg 5 // 5020 salzburg // austria |- | fon/fax +43/662/842 897 |- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+iAdLIMP39JYOy9IRAliAAJ9T79AVGjUP7tNBfRSGTeclxivPswCfbtuM
7oY4fIvRvWDoOLlavvPUzCA=
=AVXe
-----END PGP SIGNATURE-----


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to