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
-
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