Monday, March 26, 2012

Is there a limit of 256 on CHAR data?

We are creating some VIEWS that concatenate columns for output to FIXED
LENGTH TEXT FILES - with FIXED LENGTH columns.
This is being done for various transmissions - W2 files to the SS Admin,
1099 files to the IRS, eligibility files to various health organizations.
While testing today, in Query Analyzer, it appeared that saying something
like:
Cast( Cast(col1 as char(10))+Cast(Col2 as char(15))...+Cast(Colnn as
char(10)) as char(280))
The 280 was not liked. In QA we could only see a single column of I'm
thinking around 256 bytes?
Does QA have a max size for column display in the grid?QA->Menu-> Tools.. Options...Results tab. Maximum Characters per column
box. Adjust as necessary.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve Z" <szlamany@.antarescomputing_no_spam.com> wrote in message
news:Om8MaQROEHA.2468@.TK2MSFTNGP11.phx.gbl...
> We are creating some VIEWS that concatenate columns for output to FIXED
> LENGTH TEXT FILES - with FIXED LENGTH columns.
> This is being done for various transmissions - W2 files to the SS Admin,
> 1099 files to the IRS, eligibility files to various health organizations.
> While testing today, in Query Analyzer, it appeared that saying something
> like:
> Cast( Cast(col1 as char(10))+Cast(Col2 as char(15))...+Cast(Colnn as
> char(10)) as char(280))
> The 280 was not liked. In QA we could only see a single column of I'm
> thinking around 256 bytes?
> Does QA have a max size for column display in the grid?
>|||Steve,
Change the max number in Query analyzer 'tools' menu |options|'results' tab.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Steve Z" <szlamany@.antarescomputing_no_spam.com> wrote in message
news:Om8MaQROEHA.2468@.TK2MSFTNGP11.phx.gbl...
> We are creating some VIEWS that concatenate columns for output to FIXED
> LENGTH TEXT FILES - with FIXED LENGTH columns.
> This is being done for various transmissions - W2 files to the SS Admin,
> 1099 files to the IRS, eligibility files to various health organizations.
> While testing today, in Query Analyzer, it appeared that saying something
> like:
> Cast( Cast(col1 as char(10))+Cast(Col2 as char(15))...+Cast(Colnn as
> char(10)) as char(280))
> The 280 was not liked. In QA we could only see a single column of I'm
> thinking around 256 bytes?
> Does QA have a max size for column display in the grid?
>|||> The 280 was not liked. In QA we could only see a single column of I'm
> thinking around 256 bytes?
http://www.aspfaq.com/2272
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Thank you all very much - I was thinking I was crazy...
It worked like a charm.
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:e8QpGWROEHA.2704@.TK2MSFTNGP10.phx.gbl...
> Steve,
> Change the max number in Query analyzer 'tools' menu |options|'results'
tab.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Steve Z" <szlamany@.antarescomputing_no_spam.com> wrote in message
> news:Om8MaQROEHA.2468@.TK2MSFTNGP11.phx.gbl...
> > We are creating some VIEWS that concatenate columns for output to FIXED
> > LENGTH TEXT FILES - with FIXED LENGTH columns.
> >
> > This is being done for various transmissions - W2 files to the SS Admin,
> > 1099 files to the IRS, eligibility files to various health
organizations.
> >
> > While testing today, in Query Analyzer, it appeared that saying
something
> > like:
> >
> > Cast( Cast(col1 as char(10))+Cast(Col2 as char(15))...+Cast(Colnn as
> > char(10)) as char(280))
> >
> > The 280 was not liked. In QA we could only see a single column of I'm
> > thinking around 256 bytes?
> >
> > Does QA have a max size for column display in the grid?
> >
> >
>

No comments:

Post a Comment