search

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

Review and fix character set usage in various ways to access BLOB SUB_TYPE TEXT #723

Closed mrotteveel closed 1 year ago

mrotteveel commented 1 year ago

The implementation in FBClob always uses the connection character set, which is not always correct. It should either use the column character set, or maybe even request the actual blob info (which might be too much overhead though). Inspect the various ways blobs are retrieved and written, and try and fix this (maybe with a backwards compatibility option?).

mrotteveel commented 1 year ago

Rewrote blob handling to ensure it does the same on all code paths. I also tried switching from blr_quad to blr_blob2, but that caused weird issues with server-side batches, so I'll defer that to later.