db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "CY Ing" <CY....@iaSolution.net>
Subject RE: torque data type <-> database data type overview
Date Mon, 31 Mar 2003 09:21:17 GMT
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  <rick@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


Mime
View raw message