Ampersand not working for Sequelize query

Question

For whatever reason Sequelize is ignoring ampersands and I'm unable to figure out why. The rest of the query comes out right in the console (Node.Js) but in the where parameter it ignores ampersands and cuts off the rest of the string.

The problem seems to only be the ampersand as the other special characters that I've tried (not many but a few such as .) work fine.

I've also tried a raw query in Sequelize where I put literal SQL code with the ampersand and it results in the same thing. There is also no error (except for MySQL stating said entry doesn't exist which is accurate because Sequelize isn't including the ampersand and cuts off the rest of the string after it)

[Expected] Input: "Stack & Overflow" Output: "Stack & Overflow"

[Reality] Input: "Stack & Overflow" Output: "Stack "

Can you show an example of Sequelize query with an ampersand that does not work properly? — Anatoly, Nov 16 '20 at 20:08
A sample query would be something like User.findOne({ where: { name: "John & Doe"}}); — Legend28469, Nov 16 '20 at 21:39

score 1 · Accepted Answer · answered Dec 04 '20 at 16:14

After much debugging and troubleshooting I created an isolated environment. Turns out the problem all along was that I was sending data in a GET request for whatever reason. As a result & was creating separated parameters.

Fixed by sending via POST requests.

I'd imagine URL encoding could've also been a potential fix for this problem.

score 0 · Answer 2 · answered Nov 17 '20 at 10:47

0

Instead double quotes " you should use single quotes '.

This is based on PostgreSQL behavior. You can read explanation in this answer

answered Nov 17 '20 at 10:47

Andrew

88
9

Ampersand not working for Sequelize query

2 Answers2