culture settings in text to decimal casting
I would like ask about culture settings and how it influence casting from text value to decimal number.
We have an automated import from external system using delimited files and pre-stage table in...
Forum Discussion
Hi Jack,
Current connection string
Data Source=censored.database.windows.net;Initial Catalog=censored;User ID=censored;Password=censored;Max Pool Size=3000;Connect Timeout=60;Encrypt=True;TrustServerCertificate=False
Tried adding Regional=no
ended with an error: Invalid Connection String. Keyword not supported: 'regional'.
Tried adding Language=English
even thow the descrioption of this parameter was not that promissing. Did not raised an error but returned the numbers with wrong conversion.