Commented by: @aafemt

As designed. XSQLDA.sqllen is max size of data in bytes.

Commented by: @asfernandes

If you can, set the field (in code, not in database) to be described as VARCHAR (SQL_VARYING).

If you can't, tell your driver developer to do it internally (it can still report for you that field is of type CHAR).

Commented by: Reydy Valentin (lifeoryou)

What did you mean ?
I don't know XSQLDA.sqllen, it's a configuration variable ?

Commented by: @mrotteveel

This is not a bug. A char(3) character set UTF8 takes 3 * 4 = 12 bytes storage (as a UTF-8 character takes 1 - 4 bytes). This is communicated from server to client in a datastructure called (X)SQLDA. The sqllen contains the (max) length in bytes of a field.

When using Java/Jaybird 2.2 and earlier it **will** report the correct length **if** you have specified a connection character set. But if you haven't, you will be using character set NONE and it will report the length in bytes instead. In Jaybird 3 it will report the correct size even with none.

I can't speak for the PHP specifics, but it is possible it works the same and you just need to specify a connection character set.

Commented by: Reydy Valentin (lifeoryou)

Humm ok. Thank

Effectivly in Java/Jaybird 3, it's corrected and i recive good string.
But not in Php, even with the charset specified.
I think is a bug of Php PDO Driver.

I post a issue in their tracker.

Thanks all guys