Data Types as displayed

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Data Types as displayed

Don Barton

Greetings,

I have just downloaded Squirrel SQL and am trying to read the Data_Type  as displayed.  For example, TYPE_NAME is BIT, the DATA_TYPE is -7[BIT], or for DATE, the DATA_TYPE is displayed as 91[DATE].  What is the the -7 or the 91 indicate?

 

Thanks,

Don


------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|

Re: Data Types as displayed

Alexandre Peshansky
These numbers are data type codes according to ANSI or ISO standard. See http://www.cs.toronto.edu/~nn/csc309-20085/guide/pointbase/docs/html/htmlfiles/appendixedatatypecode.html

Sent from my iPhone

On Apr 12, 2016, at 11:39 PM, Don Barton <[hidden email]> wrote:

Greetings,

I have just downloaded Squirrel SQL and am trying to read the Data_Type  as displayed.  For example, TYPE_NAME is BIT, the DATA_TYPE is -7[BIT], or for DATE, the DATA_TYPE is displayed as 91[DATE].  What is the the -7 or the 91 indicate?

 

Thanks,

Don


------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users