Char Fields Everywhere!

Hi,
We are using Oracle/PeopleSoft CRM on SQL2K. I see only char fields are used
every. Varchar fields are NOT used. Is there any specific reason for it. Can
someone through some light on this subject. I am just curious.
Thanks in advance.
--SeequellWhoever wrote the app doesn't know what they're doing?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Seequell" <Seequell@.discussions.microsoft.com> wrote in message
news:A97D507B-7E93-4F17-8FC6-49E4700DE752@.microsoft.com...
> Hi,
> We are using Oracle/PeopleSoft CRM on SQL2K. I see only char fields are
> used
> every. Varchar fields are NOT used. Is there any specific reason for it.
> Can
> someone through some light on this subject. I am just curious.
> Thanks in advance.
> --Seequell|||I would like to explore more before coming to that conclusion...
--Seequell
"Adam Machanic" wrote:
> Whoever wrote the app doesn't know what they're doing?
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Seequell" <Seequell@.discussions.microsoft.com> wrote in message
> news:A97D507B-7E93-4F17-8FC6-49E4700DE752@.microsoft.com...
> > Hi,
> > We are using Oracle/PeopleSoft CRM on SQL2K. I see only char fields are
> > used
> > every. Varchar fields are NOT used. Is there any specific reason for it.
> > Can
> > someone through some light on this subject. I am just curious.
> > Thanks in advance.
> > --Seequell
>
>|||JDEdwards is the same way (at least the one place I've been that used it
was...)
Perhaps a leftover from an application that was ported from yesteryear, when
varchars were not allowed, or form a different platform (mainframe?)
Unfortunately, I;m not familiar with the history of PeopleSoft CRM...
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Seequell" <Seequell@.discussions.microsoft.com> wrote in message
news:A3348B42-5AB1-473C-80E7-634DD96D663C@.microsoft.com...
>I would like to explore more before coming to that conclusion...
> --Seequell
>
> "Adam Machanic" wrote:
>> Whoever wrote the app doesn't know what they're doing?
>>
>> --
>> Adam Machanic
>> SQL Server MVP
>> http://www.datamanipulation.net
>> --
>>
>> "Seequell" <Seequell@.discussions.microsoft.com> wrote in message
>> news:A97D507B-7E93-4F17-8FC6-49E4700DE752@.microsoft.com...
>> > Hi,
>> > We are using Oracle/PeopleSoft CRM on SQL2K. I see only char fields are
>> > used
>> > every. Varchar fields are NOT used. Is there any specific reason for
>> > it.
>> > Can
>> > someone through some light on this subject. I am just curious.
>> > Thanks in advance.
>> > --Seequell
>>|||I am not familiar with mainframe...
Is varchar field is not allowed in mainframe?
Thanks.
--Seequell
"Kevin3NF" wrote:
> JDEdwards is the same way (at least the one place I've been that used it
> was...)
> Perhaps a leftover from an application that was ported from yesteryear, when
> varchars were not allowed, or form a different platform (mainframe?)
> Unfortunately, I;m not familiar with the history of PeopleSoft CRM...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Seequell" <Seequell@.discussions.microsoft.com> wrote in message
> news:A3348B42-5AB1-473C-80E7-634DD96D663C@.microsoft.com...
> >I would like to explore more before coming to that conclusion...
> >
> > --Seequell
> >
> >
> > "Adam Machanic" wrote:
> >
> >> Whoever wrote the app doesn't know what they're doing?
> >>
> >>
> >> --
> >> Adam Machanic
> >> SQL Server MVP
> >> http://www.datamanipulation.net
> >> --
> >>
> >>
> >> "Seequell" <Seequell@.discussions.microsoft.com> wrote in message
> >> news:A97D507B-7E93-4F17-8FC6-49E4700DE752@.microsoft.com...
> >> > Hi,
> >> > We are using Oracle/PeopleSoft CRM on SQL2K. I see only char fields are
> >> > used
> >> > every. Varchar fields are NOT used. Is there any specific reason for
> >> > it.
> >> > Can
> >> > someone through some light on this subject. I am just curious.
> >> > Thanks in advance.
> >> > --Seequell
> >>
> >>
> >>
>
>

Char Fields Everywhere!

Hi,
We are using Oracle/PeopleSoft CRM on SQL2K. I see only char fields are used
every. Varchar fields are NOT used. Is there any specific reason for it. Can
someone through some light on this subject. I am just curious.
Thanks in advance.
--SeequellWhoever wrote the app doesn't know what they're doing?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Seequell" <Seequell@.discussions.microsoft.com> wrote in message
news:A97D507B-7E93-4F17-8FC6-49E4700DE752@.microsoft.com...
> Hi,
> We are using Oracle/PeopleSoft CRM on SQL2K. I see only char fields are
> used
> every. Varchar fields are NOT used. Is there any specific reason for it.
> Can
> someone through some light on this subject. I am just curious.
> Thanks in advance.
> --Seequell|||I would like to explore more before coming to that conclusion...
--Seequell
"Adam Machanic" wrote:

> Whoever wrote the app doesn't know what they're doing?
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Seequell" <Seequell@.discussions.microsoft.com> wrote in message
> news:A97D507B-7E93-4F17-8FC6-49E4700DE752@.microsoft.com...
>
>|||JDEdwards is the same way (at least the one place I've been that used it
was...)
Perhaps a leftover from an application that was ported from yesteryear, when
varchars were not allowed, or form a different platform (mainframe?)
Unfortunately, I;m not familiar with the history of PeopleSoft CRM...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Seequell" <Seequell@.discussions.microsoft.com> wrote in message
news:A3348B42-5AB1-473C-80E7-634DD96D663C@.microsoft.com...[vbcol=seagreen]
>I would like to explore more before coming to that conclusion...
> --Seequell
>
> "Adam Machanic" wrote:
>|||I am not familiar with mainframe...
Is varchar field is not allowed in mainframe?
Thanks.
--Seequell
"Kevin3NF" wrote:

> JDEdwards is the same way (at least the one place I've been that used it
> was...)
> Perhaps a leftover from an application that was ported from yesteryear, wh
en
> varchars were not allowed, or form a different platform (mainframe?)
> Unfortunately, I;m not familiar with the history of PeopleSoft CRM...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Seequell" <Seequell@.discussions.microsoft.com> wrote in message
> news:A3348B42-5AB1-473C-80E7-634DD96D663C@.microsoft.com...
>
>

Char Fields Everywhere!

Hi,
We are using Oracle/PeopleSoft CRM on SQL2K. I see only char fields are used
every. Varchar fields are NOT used. Is there any specific reason for it. Can
someone through some light on this subject. I am just curious.
Thanks in advance.
--Seequell
Whoever wrote the app doesn't know what they're doing?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"Seequell" <Seequell@.discussions.microsoft.com> wrote in message
news:A97D507B-7E93-4F17-8FC6-49E4700DE752@.microsoft.com...
> Hi,
> We are using Oracle/PeopleSoft CRM on SQL2K. I see only char fields are
> used
> every. Varchar fields are NOT used. Is there any specific reason for it.
> Can
> someone through some light on this subject. I am just curious.
> Thanks in advance.
> --Seequell
|||I would like to explore more before coming to that conclusion...
--Seequell
"Adam Machanic" wrote:

> Whoever wrote the app doesn't know what they're doing?
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Seequell" <Seequell@.discussions.microsoft.com> wrote in message
> news:A97D507B-7E93-4F17-8FC6-49E4700DE752@.microsoft.com...
>
>
|||JDEdwards is the same way (at least the one place I've been that used it
was...)
Perhaps a leftover from an application that was ported from yesteryear, when
varchars were not allowed, or form a different platform (mainframe?)
Unfortunately, I;m not familiar with the history of PeopleSoft CRM...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Seequell" <Seequell@.discussions.microsoft.com> wrote in message
news:A3348B42-5AB1-473C-80E7-634DD96D663C@.microsoft.com...[vbcol=seagreen]
>I would like to explore more before coming to that conclusion...
> --Seequell
>
> "Adam Machanic" wrote:
|||I am not familiar with mainframe...
Is varchar field is not allowed in mainframe?
Thanks.
--Seequell
"Kevin3NF" wrote:

> JDEdwards is the same way (at least the one place I've been that used it
> was...)
> Perhaps a leftover from an application that was ported from yesteryear, when
> varchars were not allowed, or form a different platform (mainframe?)
> Unfortunately, I;m not familiar with the history of PeopleSoft CRM...
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Seequell" <Seequell@.discussions.microsoft.com> wrote in message
> news:A3348B42-5AB1-473C-80E7-634DD96D663C@.microsoft.com...
>
>