Hello,
What is the suitable schema data type for x: data ? From the dictionary:
x: applies to real numbers and produces extended precision rational numbers.
It applies to integers and produces extended integers.
Sample Data:
b0 =. x: 43000000001 43000000002 43000000002 43000000003 43000000004
b1 =. ];._1 ' 0000 0000 0001 0000 0000'
b2 =. ];._1 ' 078GO5457DB627 078GO5457DB627 240HU9704ZL947 078GO5457DB627
078GO5457DB627'
b3 =. ];._1 ' Fowle Fowle Peraro Fowle Fowle'
b4 =. ];._1 ' Joshua Joshua Patrick Joshua Joshua'
b =. b0;b1;b2;b3;b4
3!:0 L:0 b
+---+-+-+-+-+
|128|2|2|2|2|
+---+-+-+-+-+
In jdb.ijs I see the following types:
0 autoid 32 64 0 1
1 boolean 8 8 0 1
2 int 32 64 0 2
3 float 64 64 0 2.1
4 byte 8 8 {.a. 'a'
5 char 8 8 ,:0$a. 'abc'
6 varchar 32 64 <'' <'abc'
7 binary 32 64 <'' <'abc'
Regards,
Yuva
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
