ORA-01406: fetched column value was truncated

[rguillen]

Hello, someone help me?

I received the following message when I open TOracleDateSet:

"ORA-01406: fetched column value was truncated"

the SLQ is:
"select D.*, D.RowId from BARD.DEPTOS_CAT D ORDER BY Depto_ID"

the schema table is

CREATE TABLE BARD.DEPTOS_CAT(
DEPTO_ID VARCHAR2(6)
CONSTRAINT c_nn_depto_id_DEPTOS_cat NOT NULL,
DEPTO_NAME VARCHAR2(40),
DEPTO_TYPE VARCHAR2(1)
CONSTRAINT c_check_depto_type_deptos_cat
CHECK (DEPTO_TYPE IN('A', 'I', 'P', 'S', 'O', 'W')),
CONSTRAINT pk_depto_id_deptos_cat PRIMARY KEY(DEPTO_ID))
ORGANIZATION INDEX TABLESPACE UNCHANGE_TS PCTTHRESHOLD 10;

Should TOracleDataSet support Organization Index table?
When I used dbexpress of delphi 6 I have no problem.

I am using Delphi 6 and DOA 3.4.6.1

Thanks!

 

[Marco Kalter]

Can you let me know your Oracle Server version and the character set you are using?

------------------
Marco Kalter
Allround Automations

 

[rguillen]

Originally posted by mkalter:
Can you let me know your Oracle Server version and the character set you are using?

Hi! mKalter
My server version is Oracle8i Enterprise Edition 8.1.7.0.0 Production With Partitioning and Object options and character set is Unicode Standard UTF8 (variable-width 8-bits encoding)

Thanks!

Richard Guillen

 

[Marco Kalter]

Have you set TOracleSession.BytesPerCharacter to bcAutoDetect?

------------------
Marco Kalter
Allround Automations

 

[rguillen]

Originally posted by mkalter:
Have you set TOracleSession.BytesPerCharacter to bcAutoDetect?

Marco Kalter
The information you provided helped.
Thank you very much for your assistance