Nvarchar support using Bods 4.2

[Former Member]

Hello Friends,

I need to push data in ms sql 2008 by taking it from excel file,  where target columns have datatype is nvarchar(max), However such data type does not exists in bods 4.2. There is option while importing file, where i can declare utf-18 as code page but not sure if that will resolve the situation.

The tables are already there in ms sql 2008 with nvarchar(max) data type. But when i import those existing table in data store from ms sql 2008 and make them as target in job. The mapping of columns to target table is not getting accepted as the target table column data type is not being mapped to valid data type.

How do i solve this, Could you please help?

[Former Member]

When using nvarchar(max), this should be converted by DS to long data type . Can you change the datatype in you schema in or schema out?

[Former Member]

It does convert to long datatype.

the target table is defined as nvarchar to handle unicode text (chinese, russian, any language) that is pretty much the requirement.

am i missing something here.?

[Former Member]

Hi,

You can declare the fileformat  code page to utf-8, the DS job server must also be able to handle utf-8 as well as the target database.

Do you actually have  any problems with  the characters being loaded?