Install necessary packages sudo apt-get -y install freetds-bin tdsodbc unixodbc Configure FreeTDS.
The example is extracted from How To Connect Azure SQL Database From Ubuntu (disclaimer: its my personal wiki). ( NAME = N'dbaccess_data', FILENAME = N'/var/opt/mssql/data/dbaccess_data.ndf', SIZE = 500MB, MAXSIZE = UNLIMITED, FILEGROWTH = 50MB ), This is a minimal but complete example how to connect to Azure SQL Database with isql from Ubuntu 14.04.1 LTS. ( NAME = N'dbaccess', FILENAME = N'/var/opt/mssql/data/dbaccess.mdf', SIZE = 8192KB, MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ), There is a palliative or bug fix to solve this behavior?ĮDIT: Steps to reproduce the problem ::::Statement to create database:::: Someone has already gone through this situation? I can't depend only on the SQLCMD, because some servers only have the ISQL.The same query, when performed through the SQLCMD, display the characters correctly.
ex: isql -Uuser -Ppass -Sserver <You can also use the 'perl style' standard input to tell isql to take info from the command line and pipe the rsults to a file. This will run the createTable script and output any results to the results.txt file.
It is a Bourne shell script that checks and reports on your configuration files.
• Make the connection in the ISQL using parameter -len_US.ISO88591 (without success) ex: isql -Uuser -Ppass -Sserver < createTable.sql > results.txt. is a diagnostic tool provided as part of FreeTDS.