Equivalent boolean? - MySQL Database

Bruce D

I'm working with VB.NET and I'm pulling data from MySQL. .NET is looking
for a boolean value...and I'm wondering what type I should make the field in
my database.

Any help is appreciated.

-bruce

Jul 23 '05 #1

Subscribe Post Reply

2830

Sal Young

If you are using MySQL 4.1.0. or newer, the BOLEAN type will be your best
bet. If not, you could use the TINYINT(1) UNSIGNED. Look it up in the
MySQL documentation under "Overview of Numeric Types".

- SYoung
"Bruce D" <br*************@hotmail.com> wrote in message
news:11*************@corp.supernews.com...

I'm working with VB.NET and I'm pulling data from MySQL. .NET is looking
for a boolean value...and I'm wondering what type I should make the field
in
my database.

Any help is appreciated.

-bruce

Jul 23 '05 #2

Rich R

"Bruce D" <br*************@hotmail.com> wrote in message
news:11*************@corp.supernews.com...

I'm working with VB.NET and I'm pulling data from MySQL. .NET is looking
for a boolean value...and I'm wondering what type I should make the field in my database.

Any help is appreciated.

-bruce

Hi Bruce,
Dot net is not looking for anything. You could make it simply alpha(1) "Y",
"N" or 0,1. It is up to you. MS used to use -1 for true and 0 for false.
Hmm?

Jul 23 '05 #3

Similar topics

Python equivalent to a C trick

by: Dan | last post by:

Is there a python equivalent of this trick in C? Logic_Test ? True_Result : False_Result Example: printf( "you have %i %s", num_eggs, num_eggs > 1 ? "eggs" : "egg" );

Python

SQL's equivalent of CASE WHEN ... END CASE

by: DaaaDaaa | last post by:

Hi, Here's what I'd like to do: table (Orders) has fields of Processed, Paid (both of boolean yes|no) etc, I want to return a count of of Total number of Orders, Number of Processed vs. Number...

Microsoft Access / VBA

C# equivalent for VB6 "End"?

by: Summit | last post by:

Does anyone know what the C# equivalent for VB6 End is? I'm starting up a form with a boolean test. If I fail, I just want to end the app. Even though I close the form, it picks up on the line...

C# / C Sharp

C# equivalent to DirectCast.

by: HolyHarley | last post by:

I have been working in VB.net and have been using the combobox to store data I need when the user selects an item. To do this, I have been creating a class of some data. Private Class...

C# / C Sharp

Is there a .Net CF equivalent of the DataReader.HasRows method?

by: charliewest | last post by:

Is there a .Net Compact Framework equivalent in the system.data.sqlserverce namespace of the .Net Framework system.data.sqlclient DataReader object's "Has.Rows" method? For example: ...

C# / C Sharp

Style: Are these two blocks of code equivalent?

by: Michael McCarthy | last post by:

This code is supposed to create a streamreader object from a stream object and I suppose use encoding if requested (enc isn't null)... The second bit is someone elses code... /// code block #1...

C# / C Sharp

IsNumeric C# equivalent

by: Stephan Bour | last post by:

IS there a C# equivalent to the VB IsNumeric function?

ASP.NET

VB equivalent of this C# code

by: Jon Paal | last post by:

what is vb equiv. of ++ shown in C# ?

Visual Basic .NET

Equivalent of Strcomp

by: Andrew Poulos | last post by:

I'm writing some ASP using js and I need to do a case sensitive SQL select. Googling gave me this: SELECT * FROM User WHERE Strcomp("Blue",,vbBinaryCompare)=0 Strcomp is from vbs. Is there a...

Javascript

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server