title: Azure nodejs site cannot connect to SQL DB that has a collation different than the default
body: <p>I have this simple nodejs page <a href="http://pastebin.com/HxMsHBbg" rel="nofollow">http://pastebin.com/HxMsHBbg</a></p>
  
  <pre><code>/**
   * Module dependencies.
   */
  
  var express = require('express'),  
      http = require('http'),
      url = require('url'),
      util = require('util');
  
  
  var nconf = require('nconf');
  var sql = require('node-sqlserver');    
  
  
  nconf.env();
  var conn = nconf.get("SQL_CONN");   
  var app = express();
  
  app.get('/', function(req, res){
      var qs = url.parse( req.url, true );        
      res.writeHead(200, {'Content-Type': 'application/json; charset=utf-8'});
  
      var alldata={}; 
  
      var select = "SELECT 1";
      sql.query(conn, select, function(err, items) {
  
          res.end(JSON.stringify(alldata));       
      });
  
  
  
  });
  http.createServer(app).listen(process.env.PORT || 3000, function(){
    console.log("Express server listening ");
  });
  </code></pre>
  
  <p>When SQL_CONN is a MSSQL DB with a collation - say - Greek_CI_AI , then I get the error </p>
  
  <p>HRESULT: 0x6d
  HTTP status: 500
  HTTP reason: Internal Server Error</p>
  
  <p>If the database in in the default collation, then there is no problem.
  Does anyone have a solution or is it a bug?</p>