Unfortunately it seems that while Mark's fix indeed makes things better, does not solve the actual issue. While I was implementing sequence metadata for Oracle I was greeted with:
Code: Select all
[2024. 11. 12. 17:31:16] db: Prepare Statement 33 : SELECT * FROM ALL_TRIGGERS
[2024. 11. 12. 17:31:16] db: Prepare Statement 34 : SELECT ALL_TAB_COLUMNS.OWNER, ALL_TAB_COLUMNS.TABLE_NAME, ALL_TAB_COLUMNS.COLUMN_NAME, ALL_TAB_COLUMNS.DATA_TYPE, ALL_TAB_COLUMNS.DATA_LENGTH, ALL_TAB_COLUMNS.DATA_PRECISION, ALL_TAB_COLUMNS.DATA_SCALE, ALL_TAB_COLUMNS.NULLABLE, ALL_TAB_COLUMNS.DATA_DEFAULT, ALL_TAB_COLUMNS.COLUMN_ID, ALL_COL_COMMENTS.COMMENTS, ALL_TAB_COLUMNS.CHAR_LENGTH FROM ALL_TAB_COLUMNS JOIN ALL_COL_COMMENTS ON ALL_COL_COMMENTS.TABLE_NAME = ALL_TAB_COLUMNS.TABLE_NAME AND ALL_COL_COMMENTS.COLUMN_NAME = ALL_TAB_COLUMNS.COLUMN_NAME AND ALL_COL_COMMENTS.OWNER = ALL_TAB_COLUMNS.OWNER WHERE ALL_TAB_COLUMNS.TABLE_NAME like 'ALL_TRIGGERS' ORDER BY ALL_TAB_COLUMNS.COLUMN_ID
[2024. 11. 12. 17:31:17] db: Execute prepared Statement 34 in 657 ms
[2024. 11. 12. 17:31:17] db: Fetch Statement 34, affected 22 row(s) in 825 ms
[2024. 11. 12. 17:31:17] db: Unprepare Statement 34
[2024. 11. 12. 17:31:17] db: Execute prepared Statement 33 in 903 ms
[2024. 11. 12. 17:31:18] db: Fetch FETCH ROW ORA-01406: fetched column value was truncated Help: https://docs.oracle.com/error-help/db/ora-01406/ (#1406)
[2024. 11. 12. 17:31:18] EZSQLException was raised while Opening dataset with the message SQL Error: ORA-01406: fetched column value was truncated
Help: https://docs.oracle.com/error-help/db/ora-01406/
Code: 1406 Message: FETCH ROW
Same query executes perfectly if I connect with AL32UTF8:
Code: Select all
[2024. 11. 12. 17:36:21] db: Prepare Statement 38 : SELECT * FROM ALL_TRIGGERS
[2024. 11. 12. 17:36:21] db: Prepare Statement 39 : SELECT ALL_TAB_COLUMNS.OWNER, ALL_TAB_COLUMNS.TABLE_NAME, ALL_TAB_COLUMNS.COLUMN_NAME, ALL_TAB_COLUMNS.DATA_TYPE, ALL_TAB_COLUMNS.DATA_LENGTH, ALL_TAB_COLUMNS.DATA_PRECISION, ALL_TAB_COLUMNS.DATA_SCALE, ALL_TAB_COLUMNS.NULLABLE, ALL_TAB_COLUMNS.DATA_DEFAULT, ALL_TAB_COLUMNS.COLUMN_ID, ALL_COL_COMMENTS.COMMENTS, ALL_TAB_COLUMNS.CHAR_LENGTH FROM ALL_TAB_COLUMNS JOIN ALL_COL_COMMENTS ON ALL_COL_COMMENTS.TABLE_NAME = ALL_TAB_COLUMNS.TABLE_NAME AND ALL_COL_COMMENTS.COLUMN_NAME = ALL_TAB_COLUMNS.COLUMN_NAME AND ALL_COL_COMMENTS.OWNER = ALL_TAB_COLUMNS.OWNER WHERE ALL_TAB_COLUMNS.TABLE_NAME like 'ALL_TRIGGERS' ORDER BY ALL_TAB_COLUMNS.COLUMN_ID
[2024. 11. 12. 17:36:21] db: Execute prepared Statement 39 in 484 ms
[2024. 11. 12. 17:36:21] db: Fetch Statement 39, affected 22 row(s) in 624 ms
[2024. 11. 12. 17:36:21] db: Unprepare Statement 39
[2024. 11. 12. 17:36:21] db: Execute prepared Statement 38 in 734 ms
[2024. 11. 12. 17:36:22] db: Fetch Statement 38, affected 180 row(s) in 1844 ms
[2024. 11. 12. 17:36:22] db: Query returned 180 record(s) in 1 second(s)
Just fyi... I have no idea if you guys can reproduce it on your end :)