[Squirrel-sql-users] A question about DB2 and columns with format CHAR () FOR BIT DATA

[Sven H. <sve...@um...>]

Hello!

We have lots of uid-columns in our DB2 database that use the following format:
CHAR () FOR BIT DATA

Squirrel does not handle these colums that well. In default the show up as:
*:j1¡_ �û36i��Cû
The closest that I can get with fiddling with View/Format -> View as..->Binary is
x'2A3A6A31A15F203FFB3336693F3F43FB'
(using native and nothing for character encoding).
The thing is, I can't use that value for things like select * from table where uid = x'2A3A6A31A15F203FFB3336693F3F43FB'. I have to use the spacing that my other SQL Editor DBeaver provides, så select * from table where uid = x'2a 3a 6a 31 de 5f 11 e7 84 33 36 69 f7 f7 43 84 ' works.

So, is there a way to get Squirrel to handle thes types of columns correctly?

* DBeaver version
  5.3.4
* Database name and version
  DB2/LINUXX8664 [SQL1005A]
* Driver name
  DB2 LUW

/ Sven Hedqvist


[cid:3BC...@um...]

Sven Hedqvist
Systemutvecklare / Systems developer
ITS / ITS
Umeå universitet / Umeå University
SE-901 87 Umeå, Sweden
+46 (0)90 786 57 86

När du skickar e-post till Umeå universitet så innebär detta att Umeå universitet behandlar dina personuppgifter. För att läsa mer om hur detta går till, klicka här https://www.umu.se/om-webbplatsen/juridisk-information/behandling-av-personuppgifter

By sending an email to Umeå University, the University will need to process your personal data. For more information, please read: https://www.umu.se/en/about-the-website/legal-information/processing-of-personal-data/