Generate Script SQLServer with varchar field only #390

Open
opereiraricardo opened this Issue Jul 8, 2016 · 1 comment

Projects

None yet

2 participants

@opereiraricardo

When creating a currency field, and generate a script sqlserver instead of the field is money or decimal is being generated the script as varchar.

@benkeen
Owner
benkeen commented Jul 9, 2016

Hey @opereiraricardo, yes this is intentional but I can see how it wouldn't always be ideal. Since the Currency data type allows things like the custom prefix/suffix ($, etc), a varchar was the only format that would work in all cases. If the user omitted the suffic/prefix, technically we could output a float in that case, but I didn't want to just mysteriously flip to a float behind the scenes.

Perhaps a new option should be added to let you choose the output type... but the field's options are a bit bloated as is. Hmm! Tricky one.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment