sql server output data types

What's the logic behind conversion from Alteryx field types to sql server types?
- I have found v_string usually goes to nvarchar (would have expected varchar)

and above some size (>1000, <6000) it changes to text (sometimes ntext) -> odd as sql server supports up to 8000

this has significant speed implications (~6x slower to text than varchar)

any ideas?

Input

Database Connection

Accepted answers

s_pichaipillai

Greg,

you are right V-String == Varchar . not sure why it considers as Nvarchar

are you creating the table On the Fly in Alteryx,

can you Design your table with Varchar if you feel that its VString? and then Map the coulumns in Alteryx

FYI : if you have your data size more than 8000 Byts, you can use Varchar (Max)

by the way, which version of SQL server are you using ?

All comments

s_pichaipillai

Greg,

you are right V-String == Varchar . not sure why it considers as Nvarchar

are you creating the table On the Fly in Alteryx,

can you Design your table with Varchar if you feel that its VString? and then Map the coulumns in Alteryx

FYI : if you have your data size more than 8000 Byts, you can use Varchar (Max)

by the way, which version of SQL server are you using ?

gregh

Thanks - I think that is what we'll have to do... looks like [text] & [varchar](max) are similar speeds, while [varchar](xx) is much faster

(sql server 2012)

jdunkerley79

Alteryx assumes strings are Unicode (http://help.alteryx.com/9.5/CodePages.htm).

Hence nvarchar is the appropriate SQL Server type if it is creating the table.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703