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 <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
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>
|