Re: [Firebird-devel] 2.0a3 bug: Wrong character set code in XSQLDA.sqlsubtype on insert

[Adriano d. S. F. <adr...@uo...>]

David Rushby wrote:

>create database '...' user 'sysdba' password '...'
>
>create table test (
>    a varchar(50) character set unicode_fss,
>    b varchar(50) character set iso8859_1
>  )
>
>[Prepare the following:]
>insert into test values (?,?)
>
>---
>
>The first XSQLVAR.sqlsubtype should contain 3 (the
>character set code for UNICODE_FSS), and the second 21
>(the character set code for ISO8859_1).  Instead, they
>both contain 21.
>
>With FB 1.5.2, the character set codes are supplied as
>expected (3, 21).
>  
>
In FB 1.5.2 things not work correctly when you are using a client 
charset different from the field charset if one is multibyte.

You see both as 21 because you are connected with ISO8859_1.
You should send ISO8859_1 strings for both fields.
Hence the sqlsubtype is 21. Note that sqllen is changed too.


Adriano