Subject Re: [Firebird-Architect] RFC: Cross database queries
Author Adriano dos Santos Fernandes
Roman Rokytskyy escreveu:
>> We greater field length in SQLDA to:
>> - Replace broken UNICODE_FSS by UTF8 in system tables
>> - Increase identifier length
>>
>
> And I'd like to sqlschema in XSQLVARs, so that we won't change the thing
> in the future.
>
Ok.

>
>> We also need a way to pass strings of unknown length.
>>
>
> Isn't that limitation of the remote protocol handler?
AFAIU, no, as data is transmited in BLR form.

Another thing I'd like to see is a new way to represent CHAR columns.

The current one, is totally dump for MBCS, as length in bytes of MBCS
CHAR columns is not fixed.

This can be done in one of this ways:
1) new type SQL_TEXT2 semantically identical to SQL_VARYING
2) using a subtype for SQL_VARYING

I prefer (2), so it will just works, and one can differentiate between
VARCHAR and CHAR columns using the subtype.


Adriano