Most Database, such as Oracle, MySQL, MS SQL have various datatypes. These data types can be divided into diffrent categories as given below:
These are described below:
P refers to precision
S refers to scale
|2||Number(P)||Fixed-point number with a scale zero and precision p|
|3||Number||Floating-point number with precision of 38|
|1||CHAR(SIZE)||Fixed length character data of length size bytes. This should be used for fixed length data. Such as codes A100, B102...,
255 bytes Default and minimum size is 1 byte.
|Variable length character string having maximum length size bytes. You must specify size
max length is 2000 characters
|3||LONG||Stores large amount of character strings of variable length
max length is up to 2 GB
|1||RAW||Stroes binary type data.
maximum length is up to 255 bytes.
|2||LONG RAW||Stroes large amount of binary type data.
Max length is up to 2 gb.