mistic100 / mistic100/jQuery-QueryBuilder
SQL query for Unicode string values. Adding N prefix
Open
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 1.7k
- Forks
- 544
- PR merge metrics
- No merged PRs in 30d
Description
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by tracing how QueryBuilder generates SQL string values and where its SQL output is configured or overridden. Confirm the generated query for a Unicode string uses the N prefix, and verify that existing SQL generation behavior remains intact.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, sql
- Domain
- backend, databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100