from the T.U.R.F. world: data truncate error - uniface 9.5

Author: ulrichmerkel@web.de (ulrich-merkel)

Perhaps someone has some idea how to cover this situation? source: http://hosted.byjones.net/turf/viewtopic.php?f=13&t=1571 data truncate error - uniface 9.5 Posted: 05.02.13 10:31 by se2mis dear all, when i retrieve data from a table through uniface 9.5 form , below error is giving. what can be the cause?. my DB table data types,field lengths and repository object data type and lengths are equal. Non-DBMS file open: C:\mitfin\gl\glfrm\glsecm02.frm Non-DBMS file close: Server: I/O function: S, mode: 0, on file/table: GLSECDHM index: 1 >= Server: Where ((DEPT_ID = '514.10')) And ((DEPT_ID = '514.10')) Server: Use Index is 1 >= ( ) Server: SEC_CD >= ( ) Server: DEPT_ID is (514.10) Server: ORACLE Driver Error [-62]: Data was truncated on fetch. ORACLE Driver Error [-62]: Data was truncated on fetch. ORACLE Driver Error [-38]: Select driver function failed. regards, se2 Re: data truncate error - uniface 9.5 Posted: 06.02.13 09:11 by Uli Hi, the reason are the limits which the database driver (here ORACLE) has internally mapping oracle datatypes to uniface datatypes. Sometimes, Oracle datatypes can hold a wider range than the database driver can handle. It looks like the value of a column in the oracle database exceeds these limits, so during the fetch the value could not be converted to the uniface counterpart.. So open your SQL*PLUS and select the specified records and examine the values. Sometimes, manipulating the driver settings may help you out of the problem. Re: data truncate error - uniface 9.5 Posted: 06.02.13 09:59 by se2mis Hi Uli i have cheeked the length of the DB field values and it is exactly same as the repository object length. so i cannot understand how to figure this. but my field value has special characters like &,<,>..etc will it be a problem? regards, meththa Re: data truncate error - uniface 9.5 Posted: 06.02.13 18:05 by Uli Hi meththa, yes, this will explain the problem, because sometimes uniface stores diacritics etc. in a 3byte sequence (there is a small hint in the references of the helpfile somewhere). In the past, we built a small component with a C10 field. You may think you can enter 10 characters of any kind. But if you enter diacritics (here in germany the umlauts are very popular) you may get a "too many characters" error if you key in 10 of these. Not sure if this is still valid since they moved to unicode support, but your error message implies it's still valid.

This page has no comments.