Monday, March 26, 2012

Long disappeared

I have just created a new database in the same computer that has a a one other databases. The other database has the "long" datatype for values but the new one doesn't allow them to be added. It's not on the list for datatypes. What setting am I missing?I am not aware of SQL Server ever allowing long as a datatype. Int and BIG_INT are allowed integer types, int is a 4 byte value, BIG_INT is 8 bytes, as I recall.|||I'm a big fat Mr. Dumbaz... Thanks. I was thinking C# not SQL.|||"long" is an Oracle datatype. It is functionally equivalent to "text" datatype in SQL Server.

No comments:

Post a Comment