SQL query for Unicode string values. Adding N prefix

mistic100 / jQuery-QueryBuilder

jQuery plugin offering an interface to create complex queries

https://querybuilder.js.org

MIT License

1.68k stars 552 forks source link

SQL query for Unicode string values. Adding N prefix #904

Open AliDehghani opened 3 years ago

AliDehghani commented 3 years ago

I'm generating statements for SQL but I want queries for string values to support Unicode values as well. How can I config QueryBuilder or override a function to add the N prefix to string values like the below query:

Category.Name LIKE('%hello%') => Category.Name LIKE(N'%hello%')

Thanks.