gertwieland opened a new issue, #2756: URL: https://github.com/apache/hop/issues/2756
### What would you like to happen? The "Insert / Update" transform automatically generates SQL code to create a target table in case it does not exist. For strings, it uses the data type "varchar" as default. In my case, I always use "nvarchar". Currently, the only way to achieve this is by performing a text replacement in an external editor. I think it would be great if there were a setting that would allow users to define the default type. Maybe a simple solution could be a mapping table like this DefaultType ReplaceWith nvarchar nvarchar The fields should probably be pulldowns that simply list all available data types, i.e. all those that are being used by Hop. I know this could lead to nonsensical selections (like replace varchar with boolean), but I would argue that this is the user's respsonsibility. This is [in relation to this conversation on Mattermost.](https://chat.project-hop.org/hop/pl/q7nd6pf9yfgcdpypbc3ypbwowc) ### Issue Priority Priority: 3 ### Issue Component Component: Hop Gui -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
