Other RDBMS databases (Re: Informix SE 7.x: Does it support data types 'text', 'varchar'??)

I am also using the following RDBMS databases (porting exercise) on Linux - Solid Server from Finland ( very good) http://www.solidtech.com/ Adabas D (from germany) http://www.adabas.com/ YardSQL (from germany) http://www.yard.de/ MySQL (from Sweden) http://www.tcx.se/ Kubl http://www.kubl.com/ Empress http://www.empress.com/ See also - http://linas.org/linux/db.html http://www.postgresql.org/ All of these run on linux and other unixes and have ODBC, JDBC good luck Lachlan Dunlop wrote: > Al, > > Linux-SE engine does *not* support types: > > Byte > Character Varying > Text > Varchar > > This is a major bummer. I just got my server up and running for an Image > database and I didn't see this coming. > > I am now looking for a database that can handle the Byte datatype and have > a Serial (or Linear) datatype that runs under linux. I am using an > application that was written in Access and requires these 2 data types. > When Informix was released (having worked with the Universal Data Server) > I was very excited! Now that has cooled a little bit because of this let > down. > > On the bright side it.... It was reported that no code changes where > required to complete the port!!! Maybe UDS will be moved with Oracle hot > on their heals. > > Again, If anyone knows of a database under Linux that supports serial > datatype, byte datatype and has an ODBC interface please let me know. I > don't have access to the source code of the application. > > Thanks > > Lach > > al dev wrote: > > > Does Informix SE 7.x (on linux) support data types like 'text' or > > 'varchar'?? > > > > When I issue commands like create table foo (aa text, bb varchar(20)); > > it gives syntax error.