The simplest way to populate your database with test data.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr
We have a CSV file that get's imported where the last column in the bunch of NULL for all entries.
When we import this, all other entries get mapped to a real NULL except that last column, which is always set to the string "NULL". Is there a way around this?
Edit: Actually, it appears that this is the issue when the type of the column is nvarchar. It will always put in the string value "NULL" instead of NULL.
- Posts: 1
- Joined: Fri Dec 13, 2013 6:32 pm
Thank you for reporting this issue to us.
I was able to reproduce the reported behavior and have logged it under the internal reference number of SDG-1047
As a workaround if all values in the column are null you can use a regexp generator for the column and just set the allow null values percentage to %100
Red Gate Software
- Posts: 209
- Joined: Mon Apr 23, 2012 2:49 pm
Return to SQL Data Generator 2
Who is online
Users browsing this forum: No registered users and 0 guests