eUser.js query

Alex Mathew
Alex Mathew
in AppWorks #1

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

Tagged:

Comments

  • Tony Wheeler
    Tony Wheeler
    #2

    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.

  • Alex Mathew
    Alex Mathew
    #3

    Hey Tony,

     

    Thanks for that information.

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform