{"action":"opened","issue":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/3752","labels_url":"https://api.github.com/repos/sequelize/sequelize/issues/3752/labels{/name}","comments_url":"https://api.github.com/repos/sequelize/sequelize/issues/3752/comments","events_url":"https://api.github.com/repos/sequelize/sequelize/issues/3752/events","html_url":"https://github.com/sequelize/sequelize/issues/3752","id":77889871,"number":3752,"title":"Need to add prefix 'N' before Unicode string when work with MSSQL","user":{"login":"colinyuran","id":5411662,"avatar_url":"https://avatars.githubusercontent.com/u/5411662?v=3","gravatar_id":"","url":"https://api.github.com/users/colinyuran","html_url":"https://github.com/colinyuran","followers_url":"https://api.github.com/users/colinyuran/followers","following_url":"https://api.github.com/users/colinyuran/following{/other_user}","gists_url":"https://api.github.com/users/colinyuran/gists{/gist_id}","starred_url":"https://api.github.com/users/colinyuran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/colinyuran/subscriptions","organizations_url":"https://api.github.com/users/colinyuran/orgs","repos_url":"https://api.github.com/users/colinyuran/repos","events_url":"https://api.github.com/users/colinyuran/events{/privacy}","received_events_url":"https://api.github.com/users/colinyuran/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-05-19T02:00:55Z","updated_at":"2015-05-19T02:00:55Z","closed_at":null,"body":"I am new to Sequelize and NodeJS, need to use it work with SQL Server 2014, and I also need to deal with Unicode string in my table columns.\r\n\r\nIn my model definition, I define a Name field with type DataTypes.STRING(255), the final real database column type is NVARCHAR(255). I can insert data with Unicode string as below sql statement:\r\n\r\n    insert into [Test] values (N'我們')\r\n\r\nDatabase can store the Chinese string correctly.\r\n\r\nBut when I use sequelize API, such as Model.create method, I will get question mark ( ???? ) in name column. After I check the NodeJS log, I find out the SQL statement generated by sequelize is as below:\r\n\r\n    INSERT INTO [Test] ([Name]) OUTPUT INSERTED.* VALUES ('我們');\r\n\r\nThere is no prefix 'N' before the Chinese string, this is why it can't store correctly in Database.\r\n\r\nI debug by myself but don't find a graceful way to change this behavior, is there any configuration not mentioned in the document?\r\n\r\nI also submit a question in stackoverflow with more details (include my codes and my debug findings, also with an ugly temporary fix). Here is the link:\r\nhttp://stackoverflow.com/questions/30303841/how-to-make-sequelize-add-n-before-unicode-string-in-its-sql-statement\r\n\r\n\r\n"}}