Get "ORA-01406: fetched column value was truncated" when using NLS_CHARACTERSET=TH8TISASCII
Closed this issue · 2 comments
vorrarit commented
My database is using NLS_CHARACTERSET=TH8TISASCII. While using stmt.query(), I got the error "ORA-01406: fetched column value was truncated".
let stmt = session.prepare("
select MARITAL_STATUS_NAME,
from MST_MARITAL_STATUS
where MARITAL_STATUS_CODE='06'
")?;
let rows = stmt.query("");
let row = rows.next();
if let Err(e) = row {
println!("{}", e);
}
quietboil commented
If you can, please try building your application using the latest (GitHub) version.
Note that in your case you would need to provide environment variable ORACLE_UTF8_CONV_FACTOR
- see Sibyl User Manual - Character Sets
vorrarit commented
Yes. It works perfect.