Hi All,

I have a database with DEFAULT CHARACTER SET WIN1250 COLLATION PXW_HUN
and a table in it:

CREATE TABLE TABLE_1 (NEV VARCHAR(60) CHARACTER SET WIN1250 COLLATE
PXW_HUN);

Connect with ISQL:
isql 1.2.3.4:MYDB -charset UTF8 -user myadmin -password mypasswd

Execute this:
SELECT * FROM TABLE_1 WHERE NAME CONTAINING 'x' COLLATE PXW_HUNDC;

Got this error:
Statement failed, SQLSTATE = 22021
Dynamic SQL Error
-SQL error code = -204
-COLLATION PXW_HUNDC for CHARACTER SET UTF8 is not defined

If connect with
isql 1.2.3.4:MYDB -user myadmin -password mypasswd

got this:
Statement failed, SQLSTATE = 22021
Dynamic SQL Error
-SQL error code = -204
-COLLATION PXW_HUNDC for CHARACTER SET NONE is not defined

Why does the connection charset count?

I tried with 3.0(.3.32850 snapshot).

Gabor