I have a DB2 datasource and while mapping Appian datastore entities to the

ankitt over 10 years ago

I have a DB2 datasource and while mapping Appian datastore entities to the existing DB2 tables I am getting this error:
"The data source schema does not match the type mappings: Wrong column type in DB2ADMIN.EMPTABLE for column EMP_NUMBER. Found: char, expected: nvarchar(255) (APNX-2-4056-000)"

In my CDT there is a field "EMP_NUMBER" of type "Text" which I am trying to map to a column "EMP_NUMBER" of type "nvarchar"
In Appian we have only "Text" for all string type fields.
Is there any solution to this problem? ...

Discussion posts and replies are publicly visible

Parents

0 venkateswarai917 over 10 years ago

i think, the database column type should be nvarchar(length)/vchar(lenght) - it supports unicode characters, if you application requires to have the unicode chars to save, you can use it and char if fixed length may not work in all the time, because your text may not store correctly. so better you can change the column type is database as vcahar(length) / nvarchar(length).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 venkateswarai917 over 10 years ago

i think, the database column type should be nvarchar(length)/vchar(lenght) - it supports unicode characters, if you application requires to have the unicode chars to save, you can use it and char if fixed length may not work in all the time, because your text may not store correctly. so better you can change the column type is database as vcahar(length) / nvarchar(length).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data