Developer forum

Forum » Integration » DW 9.10.10 - Data integration - SQL Provider: Text values with line breaks and/or quotation marks fails

DW 9.10.10 - Data integration - SQL Provider: Text values with line breaks and/or quotation marks fails

E-mail notifications
Roald Haahr
Reply
Posted on 14/10/2021 13:39:32

Hi,

Trying to import text values containing either line breaks or quotation marks will result in an error using the SQL Provider as source and Dynamicweb Provider as target. Is there a magic checkbox that I am missing or how do I solve it? Do I make a piece of code to handle the values in question?

Kind regards,
Roald


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 15/10/2021 10:01:57
Reply

Hi Roald,
I can not get it reproduced. I've used the: new line symbol and ['] and ["] symbols. Can you share your input string and what error message do you have?
Is it a source or destination provider that fails?
Kind regards, Dmitrij

 
Roald Haahr
Posted on 15/10/2021 12:46:11
Reply

Hi Dmitriy,

Turns out that line-breaks or quotation marks is probably not the issue after all. Special characters like æ, ø, å are present in the columns that i want to import. The error looks something like.

I see that the charset on the source table is set to Latin1_General_CI_AI. Is that a problem?

Kind regards, Roald

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 15/10/2021 12:49:16
Reply

This could be caused by a too-short column.

For example, if your destination column is defined as nvarchar(20) and you have a 40 character string in the source, you may get this error.

 
Roald Haahr
Posted on 15/10/2021 12:54:46
Reply

That is what I thought as well at first, but after changing the column to nvarchar(MAX) the problem persisted, so there must be some other problem.

 

You must be logged in to post in the forum