SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
The bit type fields are not displayed.

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
The bit type fields are not displayed.
Author Message
pfg1114



Joined: 30 Jun 2021
Posts: 29
Country: China

Post The bit type fields are not displayed. Reply with quote
The bit type field in the query result set of SQL Editor is not displayed. How can I solve this problem? Thank you! As shown below:


Sat Jul 17, 2021 11:43 am View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
I'm unable to reproduce your results so far. I tested with MySQL 8 and native driver. My results are attached below.
Which database driver do you use?



Sat Jul 17, 2021 8:01 pm View user's profile Send private message
pfg1114



Joined: 30 Jun 2021
Posts: 29
Country: China

Post Reply with quote
My database driver is: ADO.NET MySql.Data.MySqlClient
Sun Jul 18, 2021 9:48 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
I tried with ADO.NET MySql.Data.MySqlClient and I got results consistent with native MySQL lib. For me it works fine.

Have you customized display formats for different datatypes? Maybe you have selected black color for bit type, and as a result, you can't see it with dark background?
Mon Jul 19, 2021 10:38 am View user's profile Send private message
pfg1114



Joined: 30 Jun 2021
Posts: 29
Country: China

Post Reply with quote
Just set the displayed field type in the result set. As shown in the figure:


Mon Jul 19, 2021 9:32 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Great.

Just a note, the option that you used is for specific column names, in your case for "testbit". It won't work for a column named "something-else"until you set it explicitly. There is also another option in the global settings that sets colors by data types rather than column names.
Tue Jul 20, 2021 7:32 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.