Re: [Firebird-test] Test will not connect to database (rather long)

[Pavel C. <pc...@ib...>]

Jeff Jones - SHERIFFX napsal(a):
> I cannot find any documentation of how to use the -ch parameter in a
> CONNECT statement.  I have found where you use a SET statement before
> the CONNECT statement to set the character set, and that seems to work
> fine.  I have been unable to see how fbqa.py handles the connection.

The -ch option is cmdline switch equivalent to SET NAMES command used in
isql console before CONNECT/CREATE DATABASE statement. When you pass the
database name (and user name and password) as command line parameters to
isql, you need to use -ch when you need specific character set for
connection, as using SET NAMES is already too late. fbqa.py passes these
parameters as cmd switches because initialization scripts and actual
tests scripts feeded to isql stdin can't contain CONNECT/CREATE DATABASE
commands (for many reasons, for example they don't know the real paths),
hence it uses the -ch option.

best regards
Pavel Cisar
IBPhoenix