Sunday, February 12, 2012

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...
>
>

No comments:

Post a Comment