This is a multi-part message in MIME format.
------=_NextPart_000_0E9D_01C8C6F4.E84C1800
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I was wondering if there were any resources that have some table designs =
for common problems. Since that isn't very clear I will
give an example.
=20
We have an internal app from years back that needs to be updated. One of =
the problems is that when it was originally created, the
company only had US customers. We now have international customers and =
need to sup****t international addresses and phone numbers.
For the phone numbers that means adding a new column for international =
code or expanding the data field so that it's big enough to
hold the international prefix (still not sure which approach is best). =
But I haven't a clue as to how to set up for international
addresses.=20
=20
So I was hoping there would be a resource that I could check where these =
kinds of data sets have been 'solved' to ease the effort. I
have several books on design patterns for programming but I've not seen =
a design patterns book for common database problems. Thanks.
=20
Edward W. Rouse
ComSquared Systems, Inc.
770-734-5301
=20
=20
------=_NextPart_000_0E9D_01C8C6F4.E84C1800
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1607" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D790440514-05062008>I was =
wondering if=20
there were any resources that have some table designs for common =
problems. Since=20
that isn't very clear I will give an example.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D790440514-05062008></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D790440514-05062008>We =
have an internal=20
app from years back that needs to be updated. One of the problems is =
that when=20
it was originally created, the company only had US customers. We now =
have=20
international customers and need to sup****t international addresses and =
phone=20
numbers. For the phone numbers that means adding a new column for =
international=20
code or expanding the data field so that it's big enough to hold the=20
international prefix (still not sure which approach is best). But I =
haven't a=20
clue as to how to set up for international addresses. =
</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D790440514-05062008></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D790440514-05062008>So I =
was hoping=20
there would be a resource that I could check where these kinds of data =
sets have=20
been 'solved' to ease the effort. I have several books on design =
patterns for=20
programming but I've not seen a design patterns book for common database =
problems. Thanks.</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV align=3Dleft><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt" align=3Dleft><FONT =
face=3D"Courier New">Edward W. Rouse<?xml:namespace prefix =3D o ns =3D=20
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></P>
<P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><FONT=20
face=3D"Courier New">ComSquared Systems, Inc.<o:p></o:p></FONT></P>
<P class=3DMsoNormal></SPAN><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">770-734-5301</SPAN></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0E9D_01C8C6F4.E84C1800--
