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]
