[JIRA] Commented: (ACTIVERECORD_JDBC-94) Illegal extra 'N'-character in quoting

["mdub (JIRA)" <jira-no-reply@kenai.com>]

    [ 
http://kenai.com/jira/browse/ACTIVERECORD_JDBC-94?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=49050#action_49050
 ] 

mdub commented on ACTIVERECORD_JDBC-94:
---------------------------------------

jpzwarte wrote a patch which limits this quoting to Unicode-safe columns 
(NVARCHAR, NTEXT).

http://github.com/jpzwarte/activerecord-jdbc-adapter/commit/d3e2e9ecc9430b3b5daabb57e24e17dd862fd2a5

I've integrated his patch into my "lonelyplanet" fork, and suggest that it be 
included in the 0.9.4 release.


> Illegal extra 'N'-character in quoting
> --------------------------------------
>
>                 Key: ACTIVERECORD_JDBC-94
>                 URL: http://kenai.com/jira/browse/ACTIVERECORD_JDBC-94
>             Project: activerecord-jdbc
>          Issue Type: Bug
>          Components: MS SQL Server
>    Affects Versions: 0.9.2
>            Reporter: thomas_bjork
>
> file jdbc_mssql.rb, line 123
> There is en extra N-character in the string
> It looks like:
> "N'#{quote_string(value)}'" # ' (for ruby-mode)  
> but should look like (as in previous version, 0.9.1:
> "'#{quote_string(value)}'" # ' (for ruby-mode) 
> The extra N makes som strange sql-errors

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://kenai.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira