Go Up to isql Command Reference
Specifies the active character set to use in database transactions.
SET NAMES [charset];
Name of the active character set; default is NONE.
SET NAMES specifies the character set to use for subsequent database connections in
isql. It enables you to override the default character set for a database. To return to using the default character set, use
SET NAMES with no argument.
SET NAMES before connecting to the database whose character set you want to specify. For a complete list of character sets recognized by InterBase, see the Language Reference.
Choice of character set limits possible collation orders to a subset of all available collation orders. Given a specific character set, a specific collation order can be specified when data is selected, inserted, or updated in a column.
Example: The following statement at the beginning of a script file indicates to set the active character set to ISO8859_1 for the subsequent database connection:
SET NAMES ISO8859_1; CONNECT 'jupiter:/usr/InterBase/examples/employee.ib'; . . .