FirebirdSQL / jaybird

JDBC driver for Firebird
https://firebirdsql.org/en/jdbc-driver/
GNU Lesser General Public License v2.1
94 stars 23 forks source link

Switch to using blr_varying2/blr_text2 #692

Closed mrotteveel closed 2 years ago

mrotteveel commented 2 years ago

Jaybird is using blr_varying/blr_text when generating BLR for requests. In Firebird 5.0, this triggers an issue causing a string right truncation error with connection character set UTF8. Although that is potentially a problem with Firebird not properly handling CS_dynamic (still under investigation, see discussion "[Firebird-devel] Incorrect string right truncation errors in Firebird 5"), it would be better for Jaybird to switch to blr_varying2/blr_text2. These BLR types were - if I'm not mistaken - introduced in Firebird 1, so there shouldn't be an issue to use them.

This change should also be backported to Jaybird 4.

mrotteveel commented 2 years ago

Note to self: fix is in local shelve to continue work on server-side scrolling