[All]
How to set character set in qli?
Abstract: How to set character set in qli?
Problem:
Sub_type used in v3.3 for character set is no longer in version 4.0.
Version 4.0 uses the SQL 92 standard syntax for character set and
collation order. If one tries to input foreign character without
setting the character set, one would get error " cannot transliterate
character between character set ". The syntax to set character set to
use in isql is "set names character-set-name;". What's the equivalent
in v4.0 qli?
Solution:
The equivalent in v4.0 qli is " set character set character-set-name".
Like "set names" in isql, it must be set before making the connection
to the database.
Something like this:
(45)-> qli
Welcome to QLI
Query Language Interpreter
QLI> set character set ISO8859_1
QLI> ready /tmp/test.gdb
QLI> store xy
Enter X: 1
Enter Y: Montr#al
QLI> commit
QLI> print xy
X Y
=========== ====================
1 Montr#al
