db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emmanuel Florent <eflor...@formaguide.com>
Subject Re: torque data type <-> database data type overview
Date Mon, 31 Mar 2003 10:13:57 GMT
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
> 
> 
> 
> 
Mime
  • Unnamed multipart/mixed (inline, 8-Bit, 0 bytes)
View raw message