Re: [pgadmin-hackers] Hints

2013-04-25 Thread Dave Page
On Wed, Apr 24, 2013 at 6:09 PM, Marek Černocký ma...@manet.cz wrote:
 Hi,


 I updated Czech version of hint files. (attachment hints-cs_CZ.zip)

 While testing, I found two problems with hints.

 1. Displays garbage non-ASCII chars for UTF-8 encoded files. I changed
 code to suppose all hint files are UTF-8 encoded and load it right way.
 I fixed files, which didn't have UTF-8 header.

Are they all UTF-8? I wouldn't be surprised if some languages were
using other encodings.

 2. If config file .pgadmin3 has not set item LanguageId,
 wxLANGUAGE_UNKNOWN is used and user see en_US hints instead by your
 locale. I changed it to wxLANGUAGE_DEFAULT.

If memory serves, that's intentionally done to ensure it falls back to
the one, guaranteed supported language.

However, these are translation issues which is not an area I'm overly
confident in, so I'll leave it to Guillaume to comment further.

Thanks.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] Hints

2013-04-25 Thread Marek Černocký
Dave Page píše v Čt 25. 04. 2013 v 14:54 +0100:
 On Wed, Apr 24, 2013 at 6:09 PM, Marek Černocký ma...@manet.cz wrote:
  Hi,
 
 
  I updated Czech version of hint files. (attachment hints-cs_CZ.zip)
 
  While testing, I found two problems with hints.
 
  1. Displays garbage non-ASCII chars for UTF-8 encoded files. I changed
  code to suppose all hint files are UTF-8 encoded and load it right way.
  I fixed files, which didn't have UTF-8 header.
 
 Are they all UTF-8? I wouldn't be surprised if some languages were
 using other encodings.

It concerns three languages:
en_US: uses only ASCII and header change don't affect content
fr_FR: 3 files have header Windows-1215 although they are saved in UTF-8
- it's anyway an bug
sl_SI: uses non-ASCII chars converted to entities so header change don't
affect content

  2. If config file .pgadmin3 has not set item LanguageId,
  wxLANGUAGE_UNKNOWN is used and user see en_US hints instead by your
  locale. I changed it to wxLANGUAGE_DEFAULT.
 
 If memory serves, that's intentionally done to ensure it falls back to
 the one, guaranteed supported language.
 
 However, these are translation issues which is not an area I'm overly
 confident in, so I'll leave it to Guillaume to comment further.

Maybe some reason for this behavior. But for user it's unfriendly. He
install pgadmin3, run it first time and UI uses his language (by
locale). OK. He starts work and hint popups in English. What user will
think? It's untranslated. It will not explore hidden options to display
it in correct language.

You (or Guillaume) can suggest other code changes, but behavior should
be to display hints in right language after installation straight away.

 Thanks.
 
 --
 Dave Page
 Blog: http://pgsnake.blogspot.com
 Twitter: @pgsnake
 
 EnterpriseDB UK: http://www.enterprisedb.com
 The Enterprise PostgreSQL Company
 
 




-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] hints' display

2007-03-22 Thread Quan Zongliang
hi

Now, I try to translate hints.
First, view-without-pk.html had been translated.
But It can't be word-wraped when display in Guru Hint.

Attachment is view-without-pk.html which translated to Chinese-simplified.

Any suggest?

--
Ȩ (Quan Zongliang)
[EMAIL PROTECTED],[EMAIL PROTECTED]
Title: Guru Hints






编辑没有主键的表数据

既然表没有主键或者OID,你只能查看数据。
在没有主键情况下使用数据编辑工具不能插入新数据行和修改已经存在的数据。


为了编辑数据,pgAdmin III要求数据表具有主键,这也是一个好的数据库设计习惯。
还有一种替代方式,使用OID创建数据表。请注意OID在经过很长一段时间之后不能保证还是唯一的。
因此使用OID作为主键仅仅是第二选择。




---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [pgadmin-hackers] hints' display

2007-03-22 Thread Hiroshi Saito

Hi.

I am not certain in the reason that it cannot be read.
http://winpg.jp/~saito/pgAdmin/zn_cn.PNG
The meaning that you say is that whether the word cuts.?

Regards,
Hiroshi Saito

- Original Message - 
From: Quan Zongliang

To: pgadmin-hackers@postgresql.org
Sent: Thursday, March 22, 2007 9:22 PM
Subject: [pgadmin-hackers] hints' display

hi

Now, I try to translate hints.
First, view-without-pk.html had been translated.
But It can't be word-wraped when display in Guru Hint.

Attachment is view-without-pk.html which translated to Chinese-simplified.

Any suggest?

--
Ȩ (Quan Zongliang)
[EMAIL PROTECTED],[EMAIL PROTECTED]


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] hints' display

2007-03-22 Thread Dave Page
Quan Zongliang wrote:
 hi
 
 Now, I try to translate hints.
 First, view-without-pk.html had been translated.
 But It can't be word-wraped when display in Guru Hint.
 
 Attachment is view-without-pk.html which translated to Chinese-simplified.
 
 Any suggest?

I think it's just that the wxWidgets HTML renderer just isn't clever
enough to wrap until it finds a space to break on. That would be fine in
English, but I guess not in Chinese.

Would it change the meaning of the text to add the occasional space
character?

Regards, Dave

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [pgadmin-hackers] hints' display

2007-03-22 Thread Hiroshi Saito

Hi .

Ooops, sorry.. me.
This is normal.
http://winpg.jp/~saito/pgAdmin/en_us1.PNG
This is Japanese sample
http://winpg.jp/~saito/pgAdmin/ja_jp1.PNG
This is your hint.
http://winpg.jp/~saito/pgAdmin/zn_cn1.PNG

Ummm, This is the problem of wxWidgets.
Please put 0d0a in a suitable position to evade.
However,It is necessary to investigate the cause.

Regards,
Hiroshi Saito

- Original Message - 
From: Quan Zongliang [EMAIL PROTECTED]

To: Hiroshi Saito [EMAIL PROTECTED]
Cc: pgadmin-hackers@postgresql.org
Sent: Thursday, March 22, 2007 10:24 PM
Subject: Re[2]: [pgadmin-hackers] hints' display



Sorry.
It is tips, not hint.

Attachment is Guru Hint's screenshot.


On Thu, 22 Mar 2007 21:58:22 +0900
Hiroshi Saito [EMAIL PROTECTED] wrote:


Hi.

I am not certain in the reason that it cannot be read.
http://winpg.jp/~saito/pgAdmin/zn_cn.PNG
The meaning that you say is that whether the word cuts.?

Regards,
Hiroshi Saito

- Original Message - 
From: Quan Zongliang

To: pgadmin-hackers@postgresql.org
Sent: Thursday, March 22, 2007 9:22 PM
Subject: [pgadmin-hackers] hints' display

hi

Now, I try to translate hints.
First, view-without-pk.html had been translated.
But It can't be word-wraped when display in Guru Hint.

Attachment is view-without-pk.html which translated to Chinese-simplified.

Any suggest?

--
Ȩ (Quan Zongliang)
[EMAIL PROTECTED],[EMAIL PROTECTED]


--
权 宗亮(Quan Zongliang)
[EMAIL PROTECTED],[EMAIL PROTECTED]




---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match