0

i am using knex db with mysql in wappler low code software and i have a column in my table and column name is is_active and it have bit datatype ig it means boolean right ?

so when i use select query to return data

it should return data like

is_active : 1 or 0

or may be

is_active : true and false

but it return data like

 "is_active":  {
     "type": "Buffer",
      "data": [ 1 ]
   },

why ?

Improve this question
2
  • Make it easy to assist you, provide a complete minimal reproducible example. Also show us your current query attempt. Note, use properly formatted text (not images, not links.) Commented Sep 10, 2024 at 6:21
  • My guess is that knex has a generic converter for the bit data type, which could be longer than 1 bit. This is a knex question really that you should ask from knex developers as to the why. Commented Sep 10, 2024 at 7:27
Related questions
1429
Which MySQL data type to use for storing boolean values
1
mysql load data, issue with boolean field
0
MYSQL boolean types
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.