#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2002
    Location
    new york
    Posts
    84
    Rep Power
    13

    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
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2002
    Location
    new york
    Posts
    84
    Rep Power
    13
    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

IMN logo majestic logo threadwatch logo seochat tools logo