<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word"><head><META content="text/html; charset=utf-8" http-equiv="Content-Type">
<META content="text/html; charset=utf-8" http-equiv="Content-Type">
<STYLE TYPE="text/css">
<!-- /* Style Definitions */ p.22230605-7179-43cc-8b4a-8669660cfa74, li.22230605-7179-43cc-8b4a-8669660cfa74, div.22230605-7179-43cc-8b4a-8669660cfa74, table.22230605-7179-43cc-8b4a-8669660cfa74Table {margin:0cm; margin-bottom:.0001pt;}div.Section1 {page:Section1;}-->
</STYLE>
<META content="text/html; charset=utf-8" HTTP-EQUIV="Content-Type"><meta content="Microsoft Word 14 (filtered medium)" name=Generator><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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 STYLE="background-color: #ffffff">
<P>
<P CLASS="22230605-7179-43cc-8b4a-8669660cfa74" STYLE=" margin-bottom:5px;">
<div class=WordSection1><p class=MsoNormal>Hi all,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Does anyone know why DB Manager is reporting that my varchar fields are 4 characters longer than they actually are?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When I create a table in DB manager (say as 6 length) it reports that it is 10. Then if I look at the table in PGAdmin it says 6 length, if I try and enter more data in the text field it limits me to 6 characters.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Should I report a bug or is it just me that sees this behaviour?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>James <o:p></o:p></p></div></P><P STYLE=" margin-top:5px; margin-bottom: 10px">
<SPAN STYLE="font-family: 'Verdana','sans-serif'; color: #00227c; font-size: 10pt">
<STRONG>James Stott</STRONG>
<SPAN STYLE="font-size: 8pt">BSc (Hons) MSc</SPAN> |
Senior Professional<BR>
<SPAN STYLE="font-size: 8pt"><B STYLE="font-weight: bold">Nicholas Pearson Associates </B> | 30 Brock Street | Bath | BA1 2LN<BR>
<B>T:</B>
01225 445548
| <B>M:</B>
-<BR>
<A HREF="http://www.npaconsult.co.uk/" STYLE="font-family: 'Verdana','sans-serif'; color: #00227c; font-size: 8pt; text-decoration: none;"><STRONG>www.npaconsult.co.uk</STRONG></A>
</SPAN>
</SPAN>
<BR>
</P>
</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" STYLE="border: none; outline-style: none; border-collapse: collapse; padding: 0;
margin: 0;" WIDTH="700">
<TR>
<TD>
<A HREF="http://www.npaconsult.co.uk/" STYLE="outline-width: 0; border-collapse: collapse; text-decoration: none; outline-style: none;
border-style: none; margin: 0; padding: 0;">
<IMG ALT="Nicholas Pearson Associates, Logo" BORDER="0" SRC="cid:NPA_Logo.jpg@20ca37aa.62b145ea"></A><A HREF="http://www.npaconsult.co.uk/about-news.asp" STYLE="outline-width: 0; border-collapse: collapse; text-decoration: none; outline-style: none;
border-style: none; margin: 0; padding: 0;"><IMG ALT="Nicholas Pearson Associates, Latest News" BORDER="0" SRC="cid:Email_Footer_News.jpg@884cde69.0a594c93"></A>
</TD>
</TR>
</TABLE>
<P STYLE="margin-top: 7.5px; margin-bottom: 7.5px; text-align: left; color: #000000;
font-size: 7pt; font-family: Verdana;">
<A HREF="http://www.npaconsult.co.uk/terms.asp" STYLE="text-decoration: none; color: #000000;">
Information and Registered Address</A>
</P>
<P STYLE="margin-top: 5px; margin-bottom: 10px; text-align: left; color: #666666;
font-size: 7pt; font-family: Verdana;">
This Electronic Transmission is intended only for the attention of the addressee.
It may contain privileged and confidential information. If you are not the person
for whom it is intended, you must not copy, distribute or take any action in reliance
on it. If you have received this electronic transmission in error please notify
us immediately by telephone, delete the transmission and destroy any hard copies.
</P>
<P STYLE="margin-top: 5px; margin-bottom: 10px; text-align: left; color: #666666;
font-size: 7pt; font-family: Verdana;">
Nicholas Pearson Associates has used all reasonable efforts to ensure that this
message and any attachments are free from viruses.</P>
<P STYLE="margin-top: 5px; margin-bottom: 10px; text-align: left; color: #666666;
font-size: 7pt; font-family: Verdana;">
Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225
445548, Fax: +44 (0) 01225 312387, Website: <A HREF="http://www.npaconsult.co.uk/">http://www.npaconsult.co.uk</A></P>
</BODY></HTML>