Thread: [Phpwebsite-developers] datatypes: tinyint

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Is tinyint a sql-standard datatype?  I was going to use it as 0/1 bit type 
of field, but thought I should just go with a char(1) to ensure cross-dbms 
compatibility.

Don.

> Is tinyint a sql-standard datatype?  I was going to use it as 0/1 bit
> type  of field, but thought I should just go with a char(1) to ensure
> cross-dbms  compatibility.

Good question. If anyone can confirm that it is not, we can substitute.

I will do some Googling and see what I can find.

-- 
Matthew McNaney
Internet Systems Architect
Electronic Student Services
Appalachian State University
Phone: 828-262-6493
phpwebsite.appstate.edu
ess.appstate.edu

First hit:

http://candle.pha.pa.us/main/writings/pgsql/sgml/datatype.html#DATATYPE-INT

Quote:
"5.1.1. The Integer Types
The types smallint, integer, bigint store whole numbers, that is, numbers
without fractional components, of various ranges."

So, we can either change tinyint to int or char.

I am unsure of which way to vote. Comments? Space concerns?

Matt

-- 
Matthew McNaney
Internet Systems Architect
Electronic Student Services
Appalachian State University
Phone: 828-262-6493
phpwebsite.appstate.edu
ess.appstate.edu

Probably smallint would be the next logical step.  It is standard sql.  
Also in my research and to answer an earlier question:  date, time, and 
timestamp are standard data types.

Don.

On Sun, 5 Jan 2003, Matthew McNaney wrote:

> First hit:
> 
> http://candle.pha.pa.us/main/writings/pgsql/sgml/datatype.html#DATATYPE-INT
> 
> Quote:
> "5.1.1. The Integer Types
> The types smallint, integer, bigint store whole numbers, that is, numbers
> without fractional components, of various ranges."
> 
> So, we can either change tinyint to int or char.
> 
> I am unsure of which way to vote. Comments? Space concerns?
> 
> Matt
> 
> 
> 

> Probably smallint would be the next logical step.  It is standard sql.

+1 to smallint.

Matt

+ from me too for smallint

we will need to do a search and replace on all the current install.sal files.

Steven

>> Probably smallint would be the next logical step.  It is standard sql.
>
> +1 to smallint.
>
> Matt
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers

-- 
Steven Levin
Electronic Student Services
Appalachian State University
Phone: 828.262.2431
PhpWebsite Development Team
URL: http://phpwebsite.appstate.edu
Email: st...@NO...