Data Services General error;274 inserted value too large for column

[Former Member]

Hi

I get this error (below) when copying data from HANA data base to another HANA data base. The work around is to extend the column in the target.

My question is why is this happening as I am moving data from HANA to HANA ?

I think the issue is to do with unicode charcater in a field eg 1/4 ..is a special unicode character.

I think this is a bug as DS imports a column definition a varchar(32) but the target must be manually changed to varchar(40).

Is there some settings in DS or the target database.?

In my case when moving from a erp_table via odbc to a new HANA table in another database, I seen this when moving from various HANA data bases generally ERP or CRM hana tables -> to new blank hana database even using the older ftp or scp. still gets this error.

Is this a bug , is there a setting that can be chaneg rather that constantky increasing teh column when someone puts in a chinese chracter etc..

ODBC data source <XXX.XXX.XXX.au> error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB SO][HDBODBC]
                                                            

General error;274 inserted value too large for column

[former_member187605 · Accepted solution]

No bug at all.

Use NVARCHAR data type instead of VARCHAR. And all your unicode issues will mysteriously disappear.