Helpful Information
 
 
Category: Database Management
datatypes and miniSQL(mSQL)

Greetings All,

The site I'm currently working on is running an mSQL database, and my question is:

Exactly what datatypes are supported??

I performed a google search and discovered there isn't much support for mSQL. Are BLOBS supported?? This will pose a problem if not, given the fact that I must store images, audio, and somewhat large amounts of text...

Any thoughts, ideas, links, etc. would be greatly appreciated. Thanks!!

justin_dago

mSQL version 1.x supports the following datatypes:

int (4 bytes) -2147483646 <= i <= 2147483647
real (8 bytes) 4.94E-324 <= x <= 1.79E+308, -1.79E+308 <= x <= -4.94E-324
char



mSQL version 2.x supports the following datatypes:


int (4 bytes) -2147483646 <= i <= 2147483647
uint (4 bytes) 0 <= i <= 4294967295
real (8 bytes) 4.94E-324 <= x <= 1.79E+308, -1.79E+308 <= x <= -4.94E-324
char
text
date dd-mon-yy, for example 12-May-97
time
money










privacy (GDPR)