Import-DbaCsv and AutoCreateTable - nvarchar columns? #7920
Unanswered
match-gabeflores
asked this question in
Ideas
Replies: 1 comment
-
Bug here: |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I notice that when autocreateTable is selected, it creates the table using varchar(max). That's fine since I just want to get the table loaded but can there be an option to use nvarchar(max) in case the file includes unicode characters.
The workaround is easy - create the table beforehand with the right datatypes (or alternatively use this script as the baseline and then changing the column types to nvarchar)
A cvs containing unicode characters won't import correctly.
abc.csv
.
Beta Was this translation helpful? Give feedback.
All reactions