language SQL Azure Databases

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
egaraset
Posts: 3
Joined: Thu 21 Dec 2006 15:39

language SQL Azure Databases

Post by egaraset » Tue 19 Jul 2016 09:05

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: language SQL Azure Databases

Post by ViktorV » Tue 19 Jul 2016 13:11

Please clarify, what you mean by "possible to change the language on the server side". How do you do it not using dbExpress?

egaraset
Posts: 3
Joined: Thu 21 Dec 2006 15:39

Re: language SQL Azure Databases

Post by egaraset » Tue 19 Jul 2016 15:46

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: language SQL Azure Databases

Post by ViktorV » Wed 20 Jul 2016 12:28

Devart dbExpress driver for SQL Server has no option or a connection parameter for setting language on connection to Azure SQL Server.

Post Reply