Page 1 of 1

language SQL Azure Databases

Posted: Tue 19 Jul 2016 09:05
by egaraset
There's any way to set, by dbexpress driver, the azure sql database language ? The data conversion format is not valid with data strings.
With azure is not posible to change the language on the server side.

Thank's

Toni

Re: language SQL Azure Databases

Posted: Tue 19 Jul 2016 13:11
by ViktorV
Please clarify, what you mean by "possible to change the language on the server side". How do you do it not using dbExpress?

Re: language SQL Azure Databases

Posted: Tue 19 Jul 2016 15:46
by egaraset
With Azure SQL Server databases you can not specify the user language. Is not an active option.

We work with spanish language with data format dd/mm/yyyy.

Azure SQL only works with english language.

You can set in every query 'set language = spanish'.

My question is there's an option in the driver or in the paramteres of sql connection to set that.

Thank's

Toni

Re: language SQL Azure Databases

Posted: Wed 20 Jul 2016 12:28
by ViktorV
Devart dbExpress driver for SQL Server has no option or a connection parameter for setting language on connection to Azure SQL Server.