MySQL/NodeJS selecting where/like Japanese characters

Question

I have the following query to select a list of vocabulary from a Japanese dictionary.

SELECT * FROM dictionary WHERE from_local = 1 AND (word like '%後%' or reading like '%後%')

Running this program in HeidiSQL, it works as expected. I feel like it could be a charset issue but I don't think it would work at all if this were the case. (See screenshot)

My problem occours when I try to run this query in my Node.js app. The results return empty.

I am using npm's mysql library. The dbQuery method is a helper function I made (Pastebin link)

import { dbQuery } from '../db'

const search = async(query) => {
    try {
        let sql = 'SELECT * FROM dictionary WHERE'
        sql += ' from_local = ? AND'
        sql += ' (word = ? OR reading = ?)'
        const params = [1, '%'+query+'%', '%'+query+'%']

        console.log('dictionary DB', {query, sql, params})

        return await dbQuery(sql, params)
    }
    catch(err) {
        console.log('search Error', err)
    }
}

Have a look here, and also read about using prepared statements in your Node JS code. — Tim Biegeleisen
– Tim Biegeleisen, Commented Feb 25, 2019 at 6:42
I'll have a look thanks. Also I am using prepared statements via my helper method (Check pastebin link) — Ben
– Ben, Commented Feb 25, 2019 at 6:43

Ben · Accepted Answer · 2019-02-25 09:03:03Z

0

Soultion I was being stupid

I had forgot to change the = to LIKE in my query

answered Feb 25, 2019 at 9:03

Ben

5,7979 gold badges37 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL/NodeJS selecting where/like Japanese characters

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related