Opening reset password link causes ` text and nvarchar are incompatible` error
Hello re-posting again with some better text:
I am currently implementing password reset functionality. The problem I got stuck on is that when I open reset link (received in email) server throws this error
SERVER_ERROR: [Error: The data types text and nvarchar are incompatible in the equal to operator.]
I am using MS SQL and email is stored in varchar(255) format, and I guess during SQL query for email library uses different nvarchar format.
As SQL schema was generated by BetterAuth I don't really have control over it, unless I could somehow change it so email would also be stored as nvarchar or change how this password reset query is being created. Or perhaps there are better solutions for this?
0 Replies