Thread: Underscores not visible in the output of SQL Query (SQLGrid)
Hi all,
If you execute a query in the query browser and the result contains underscores like "A_B", then the '_' is not visible in the result.
Example query: SELECT relname FROM pg_class ORDER BY relname LIMIT 5;
The following patch fixes it.
Attachment
On Tue, Jan 31, 2012 at 9:42 AM, Sachin Srivastava <sachin.srivastava@enterprisedb.com> wrote: > Hi all, > > If you execute a query in the query browser and the result contains > underscores like "A_B", then the '_' is not visible in the result. > > Example query: SELECT relname FROM pg_class ORDER BY relname LIMIT 5; > > The following patch fixes it. Hi, I see them just fine on Mac. Is this platform or even font-specific? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Feb 1, 2012, at 4:39 PM, Dave Page wrote: > On Tue, Jan 31, 2012 at 9:42 AM, Sachin Srivastava > <sachin.srivastava@enterprisedb.com> wrote: >> Hi all, >> >> If you execute a query in the query browser and the result contains >> underscores like "A_B", then the '_' is not visible in the result. >> >> Example query: SELECT relname FROM pg_class ORDER BY relname LIMIT 5; >> >> The following patch fixes it. > > Hi, > > I see them just fine on Mac. Is this platform or even font-specific? I have seen this on Windows 7 (32 bit) and Windows Server 2008 (64 bit), with default font, though I have verified it onCentOS 5 (32 bit) and the issues is not there. So i guess its a Windows specific issue. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company.
On Wed, Feb 1, 2012 at 1:12 PM, Sachin Srivastava <sachin.srivastava@enterprisedb.com> wrote: > > On Feb 1, 2012, at 4:39 PM, Dave Page wrote: > >> On Tue, Jan 31, 2012 at 9:42 AM, Sachin Srivastava >> <sachin.srivastava@enterprisedb.com> wrote: >>> Hi all, >>> >>> If you execute a query in the query browser and the result contains >>> underscores like "A_B", then the '_' is not visible in the result. >>> >>> Example query: SELECT relname FROM pg_class ORDER BY relname LIMIT 5; >>> >>> The following patch fixes it. >> >> Hi, >> >> I see them just fine on Mac. Is this platform or even font-specific? > > I have seen this on Windows 7 (32 bit) and Windows Server 2008 (64 bit), with default font, though I have verified it onCentOS 5 (32 bit) and the issues is not there. So i guess its a Windows specific issue. Hi Can you please test with non-standard font sizes, and adjust the patch accordingly so it only affect Windows if necessary. Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Wed, Feb 1, 2012 at 7:38 PM, Dave Page <dpage@pgadmin.org> wrote:
On Wed, Feb 1, 2012 at 1:12 PM, Sachin SrivastavaHi
<sachin.srivastava@enterprisedb.com> wrote:
>
> On Feb 1, 2012, at 4:39 PM, Dave Page wrote:
>
>> On Tue, Jan 31, 2012 at 9:42 AM, Sachin Srivastava
>> <sachin.srivastava@enterprisedb.com> wrote:
>>> Hi all,
>>>
>>> If you execute a query in the query browser and the result contains
>>> underscores like "A_B", then the '_' is not visible in the result.
>>>
>>> Example query: SELECT relname FROM pg_class ORDER BY relname LIMIT 5;
>>>
>>> The following patch fixes it.
>>
>> Hi,
>>
>> I see them just fine on Mac. Is this platform or even font-specific?
>
> I have seen this on Windows 7 (32 bit) and Windows Server 2008 (64 bit), with default font, though I have verified it on CentOS 5 (32 bit) and the issues is not there. So i guess its a Windows specific issue.
Can you please test with non-standard font sizes, and adjust the patch
accordingly so it only affect Windows if necessary.
I have tested with different fonts and the issue comes with Microsoft Sans Serif, Courier New, Times New Roman (and some more) with size 9. If i increase the font size to 10. It displays fine.
So can we treat it as non-issue?
Thanks.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Regards,
Sachin Srivastava
EnterpriseDB, India
On Mon, Feb 6, 2012 at 10:47 AM, Sachin Srivastava <sachin.srivastava@enterprisedb.com> wrote: > > > On Wed, Feb 1, 2012 at 7:38 PM, Dave Page <dpage@pgadmin.org> wrote: >> >> On Wed, Feb 1, 2012 at 1:12 PM, Sachin Srivastava >> <sachin.srivastava@enterprisedb.com> wrote: >> > >> > On Feb 1, 2012, at 4:39 PM, Dave Page wrote: >> > >> >> On Tue, Jan 31, 2012 at 9:42 AM, Sachin Srivastava >> >> <sachin.srivastava@enterprisedb.com> wrote: >> >>> Hi all, >> >>> >> >>> If you execute a query in the query browser and the result contains >> >>> underscores like "A_B", then the '_' is not visible in the result. >> >>> >> >>> Example query: SELECT relname FROM pg_class ORDER BY relname LIMIT 5; >> >>> >> >>> The following patch fixes it. >> >> >> >> Hi, >> >> >> >> I see them just fine on Mac. Is this platform or even font-specific? >> > >> > I have seen this on Windows 7 (32 bit) and Windows Server 2008 (64 bit), >> > with default font, though I have verified it on CentOS 5 (32 bit) and the >> > issues is not there. So i guess its a Windows specific issue. >> >> Hi >> >> Can you please test with non-standard font sizes, and adjust the patch >> accordingly so it only affect Windows if necessary. > > > I have tested with different fonts and the issue comes with Microsoft Sans > Serif, Courier New, Times New Roman (and some more) with size 9. If i > increase the font size to 10. It displays fine. > > So can we treat it as non-issue? Yes, I think so. Thanks! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company