Date: Wed, 4 Mar 2009 19:16:27 -0600
Reply-To: "Peck, Jon" <peck@spss.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Peck, Jon" <peck@spss.com>
Subject: Re: Variable width
In-Reply-To: A<1F5EFE773804DE459296D5389810B1D8C74768@MIAEMAILEVS2.spss.com>
Content-Type: text/plain; charset="US-ASCII"
One clarification. The limit is in bytes, not characters. In the traditional code page mode, most Asian characters take two bytes. In Unicode mode (available in 16 and later) Most accented characters and others not in the western European character set take two bytes, and most Asian characters take three.
Regards,
Jon Peck
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of SPSS Support
Sent: Wednesday, March 04, 2009 5:03 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: [SPSSX-L] Variable width
Hi Deepa,
As of SPSS 15, the maximum string width is 32,767. If the variable width was 200 characters and the column width for the variable was 50 characters, for example, you could type 200 characters into a cell for that variable, even though you only see 50 characters at a time. The view for the cell will continue to shift to the right as you type.
What type of database (including version number, if known) was involved?
Did you open it from the ODBC wizard (File->Open Dataset->New Query) or from File->Open->Data?
What were the Width and Columns values in the Variable View for that variable?
David Matheson
SPSS Statistical Support
________________________________________
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Deepa Bhat
Sent: Wednesday, March 04, 2009 9:58 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Variable width
Hi everyone,
This may sound like a simple question.
How large can the variable width be?
I have this database that was sent to me and it seems like for all the string variables, the words have been cut off after 50 characters. I try to make it larger, but I still can't type more than 50 characters. I have SPSS 17.
Any idea on what is going on?
Thanks,
Deepa
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
| 
