You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Joachim Müller <jo...@wemove.com> on 2003/03/31 11:06:52 UTC
torque data type <-> database data type overview
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?
Best regards.
Joachim
Re: torque data type <-> database data type overview
Posted by Emmanuel Florent <ef...@formaguide.com>.
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
eflorent@devaki.org
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:rick@subnet.at]
> 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 <ri...@subnet.at>
> |-
> | 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: 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
>
>
>
>
RE: torque data type <-> database data type overview
Posted by CY Ing <CY...@iaSolution.net>.
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:rick@subnet.at]
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 <ri...@subnet.at>
|-
| 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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: torque data type <-> database data type overview
Posted by peter riegersperger <ri...@subnet.at>.
-----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 <ri...@subnet.at>
|-
| 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-----