<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.6058" name=GENERATOR>
<STYLE>@font-face {
font-family: SimSun;
}
@font-face {
font-family: SimSun;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: @SimSun;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-AU vLink=purple link=blue bgColor=white>
<DIV><FONT face=Arial size=2>Hello Mark K and Matt</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1. </FONT>So Access doesn't have a true Boolean
datatype.... and neither does Filemaker (one uses a number field with values of
non-zero or 0). Which RDBMS <B>does</B> have a fair dinkum native Boolean
datatype?</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Access does have a "fair dinkum" Boolean data type
- it's a 1 bit field and that means it can be either 0 or 1 and you can't get
much more Boolean than that. Null is not allowed. As the setter-upper of the db
you can choose a number of ways to display it, the default being
yes/no.</FONT><BR><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"></SPAN></DIV>
<DIV><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><FONT
face=Arial><FONT size=2>2. I always thought Boolean operators
were:</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN-LEFT: 72pt"><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><FONT
face=Arial><FONT size=2>NOT</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN-LEFT: 72pt"><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><FONT
face=Arial><FONT size=2>OR</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN-LEFT: 72pt"><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><FONT
face=Arial><FONT size=2>AND</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><FONT
face=Arial><FONT size=2>Thus in the sample paper M / F the Boolean operator
would OR?</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><FONT
face=Arial><FONT size=2></FONT></FONT></SPAN> </DIV>
<DIV class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><FONT
face=Arial color=#000000 size=2>But the question doesn't ask about operator (or
have I missed something?). It asks about data type and I agree with other
comments: F/M is the only possible answer because it's a two value field, but I
wouldn't have thought it would be a good idea for a number of reasons including
every time you want to display it you have to do an IF operation
(IF(gender,"Female","Male") or something), also, in Access at least, NULL would
not be allowed and I can think of circumstances where this would a be valid
entry (for example, maybe we just don't know, in which case NULL would be more
valid than a forced True or False)</FONT></SPAN></DIV>
<DIV class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><FONT
face=Arial color=#000000 size=2></FONT></SPAN> </DIV>
<DIV class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"></SPAN> </DIV></BODY></HTML>