search

sqlectron / sqlectron-gui

A simple and lightweight SQL client desktop with cross database and platform support.
https://sqlectron.github.io/
MIT License
4.55k stars 522 forks source link

sqlectron doesnt decode bytea data #686

Open ilyasd7 opened 2 years ago

ilyasd7 commented 2 years ago

It shows encoded characters when I query bytea field. Works fine with sqlectron_1.35.0_amd64.deb but not with 1.37.1

MasterOdin commented 2 years ago

What database adapter are you using? What's the version of the database you're connecting to?

tomschulze commented 2 years ago

im not sure if its related; i see comma separated ascii codes for data stored in varbinary fields, e.g. 77,97,105,110,95,80,97,103,101; before (sry, dont know the exact version anymore) the characters were displayed. i tried both the mysql and mariadb adapters. 

mysql --version
# mysql  Ver 15.1 Distrib 10.5.11-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
ilyasd7 commented 2 years ago

What database adapter are you using? What's the version of the database you're connecting to? postgresql-11.7-2