By: Borland Staff
Abstract: set character set character-set-name is how you set the character set in QLI
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?
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:
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> print xy
Trial Download Week!
Click here to download a free 30-day trial of InterBase XE3 Server or ToGo editions. Or download a free non-expiring Developer Edition >
More InterBase Info
InterBase XE3 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase_ on Twitter
Server Response from: ETNASC01