>Paul Hammant wrote: >> >> Ulrich, >> >> >FYI, the SQL-92 datatypes are: >> > >> >INTEGER, SMALLINT, NUMERIC, DECIMAL >> >REAL, DOUBLE, FLOAT >> >CHAR, VARCHAR >> >BIT >> >DATE, TIME, TIMESTAMP, INTERVAL >> > >> >All the other types you mentioned are PROPRIETARY, don't waste your time >> >implementing proprietary Oracle or Sybase constructs. Additionally I >> >think supporting VARCHAR would be enough at first, the other datatypes >> >can be derived from it. >> > >> That's probably good advice. The mappings between those and normal Java >> objects are mostly quite good. > >Also, consider that things like stored procedures, triggers, user >management, indexes are not part of any standard, they are also >proprietary concepts and solved differently in every database server. Maybe first of all, before starting wild coding, we should limitate the functionalities of this DB server. What should he be able to do and what not: Datatypes? Functions? Any other DB objects like triggers,indexes?
Maybe we should take, according to Ulrich the SQL92 Standard as core functionality first. But I would keep the other functionalities in mind, you never know. Cheers Gerhard -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
