eUser.js query

Alex Mathew

Hi All,

 

What does the N do in the following statement in the eUser.js mean?

 
SELECT eUserName FROM eUser WHERE UPPER(eUserName) = UPPER(N'" + username + "') AND ePassword = '" + password + "'"

 

We are trying to change the eUser script but cannot seem to understand how this works.

 

Thanks,

Alex

Tony Wheeler

That 'N' is simply a SQL keyword that says the following string is Unicode. You see the same thing if you use SQL Server Management Studio's visual Query Builder.