file. Sometimes, however, this does not work well,
especially for files written by old versions of SPSS or @pspp{}. Specify
the @subcmd{ENCODING} subcommand with an @acronym{IANA} character set name as its string
-argument to override the default. The @subcmd{ENCODING} subcommand is a @pspp{}
-extension.
+argument to override the default. Use @cmd{SYSFILE INFO} to analyze
+the encodings that might be valid for a system file. The
+@subcmd{ENCODING} subcommand is a @pspp{} extension.
@cmd{GET} does not cause the data to be read, only the dictionary. The data
is read later, when a procedure is executed.
/SHEET=@{NAME '@var{sheet_name}', INDEX @var{n}@}
/CELLRANGE=@{RANGE '@var{range}', FULL@}
/READNAMES=@{ON, OFF@}
- /ASSUMEDVARWIDTH=@var{n}.
+ /ASSUMEDSTRWIDTH=@var{n}.
@end display
@cindex Gnumeric
cell containing the first datum for the variable.
If this cell is of string (text) format, then the width of the variable is
determined from the length of the string it contains, unless the
-@subcmd{ASSUMEDVARWIDTH} subcommand is given.
+@subcmd{ASSUMEDSTRWIDTH} subcommand is given.
The @subcmd{SHEET} subcommand specifies the sheet within the spreadsheet file to read.
There are two forms of the @subcmd{SHEET} subcommand.
If @subcmd{/READNAMES=OFF} is
used, then the variables receive automatically assigned names.
-The @subcmd{ASSUMEDVARWIDTH} subcommand specifies the maximum width of string
+The @subcmd{ASSUMEDSTRWIDTH} subcommand specifies the maximum width of string
variables read from the file.
If omitted, the default value is determined from the length of the
string in the first spreadsheet cell for each variable.
GET DATA /TYPE=PSQL
/CONNECT=@{@var{connection info}@}
/SQL=@{@var{query}@}
- [/ASSUMEDVARWIDTH=@var{w}]
+ [/ASSUMEDSTRWIDTH=@var{w}]
[/UNENCRYPTED]
[/BSIZE=@var{n}].
@end display
The @subcmd{SQL} subcommand is mandatory.
It must be a valid SQL string to retrieve data from the database.
-The @subcmd{ASSUMEDVARWIDTH} subcommand specifies the maximum width of string
+The @subcmd{ASSUMEDSTRWIDTH} subcommand specifies the maximum width of string
variables read from the database.
If omitted, the default value is determined from the length of the
string in the first value read for each variable.
the file. Sometimes, however, this does not work well, especially for
files written by old versions of SPSS or @pspp{}. Specify the
@subcmd{ENCODING} subcommand with an @acronym{IANA} character set name
-as its string argument to override the default. The @subcmd{ENCODING}
-subcommand is a @pspp{} extension.
+as its string argument to override the default, or specify
+@code{ENCODING='DETECT'} to analyze and report possibly valid
+encodings for the system file. The @subcmd{ENCODING} subcommand is a
+@pspp{} extension.
@cmd{SYSFILE INFO} does not affect the current active dataset.