Subject Re: [firebird-support] UNION field BLOB SUB_TYPE 0 with different charset
Author Kjell Rilbe
Den 2011-06-15 12:46 skrev b0bik2000 såhär:
>
>
> I'm not sure is it feature / bug, but for sure such behavior is strange:
>
> I've database with two tables. First table contains blob sub_type 1
> charset none field, the second table contains blob sub_type 1 charset
> win1250 field. Database charset is WIN1250.
>
> Under 2.0.3:
>
> SELECT
> DESCR
> FROM TABLE1
> UNION
> SELECT
> DESCR
> FROM TABLE2
>
> throws:
>
> Engine Code : 335544378
> Engine Message :
> feature is not supported
>
> But:
>
> SELECT
> DESCR
> FROM TABLE2
> UNION
> SELECT
> DESCR
> FROM TABLE1
>
> works : )
>
> Under 2.1.4 both query are OK.
>
> If it is already fixed bug (in 2.0.6) - forgive me.

Actually, I fond it somewhat strange that it works in 2.1.4, because in
one case the end result would be charset none and in the other, the end
result would be charset win1250. In the former case, it will
transliterate win1250 to none, which I assume is a no-op, while in the
second case it has to transliterate from charset none to win1250, which
I would assume throws an error. Or is this also a no-op?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64