Using tinyint(1) in MySql

G

Guest

Hi,

In MySql db doc ch 11

TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned range is
0 to 255.
BIT
BOOL
BOOLEAN
These are synonyms for TINYINT(1). The BOOLEAN synonym was added in MySQL
4.1.0. A value of zero is considered false. Non-zero values are considered
true. In the future, full boolean type handling will be introduced in
accordance with standard SQL.

I'm trying to use the tinyint(1) as a replace for boolean values True and
False in asp.net with the values 0 and 1, but I always get the followinf
errormessage

Input string was not in a correct format.

Any ideas?

TIA

Kenneth P
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,777
Messages
2,569,604
Members
45,216
Latest member
topweb3twitterchannels

Latest Threads

Top