Thread: pgmonitor
What happend with pgmonitor? -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; --------------------------------------------------------- Martín Marqués | Programador, DBA Centro de Telemática | Administrador Universidad Nacional del Litoral ---------------------------------------------------------
i want to list non-system tables with psql and get the following error. any alternatives? Thanks. EPost-# \dt ERROR: invalid byte sequence for encoding "UNICODE": 0xed my database used UNICODE as the encoding. and the OS is win2k pro wich simplified chinese as default language.
Am Montag, den 01.08.2005, 16:19 -0600 schrieb YL: > i want to list non-system tables with psql and get the following error. any > alternatives? Thanks. > > EPost-# \dt > ERROR: invalid byte sequence for encoding "UNICODE": 0xed > > my database used UNICODE as the encoding. and the OS is win2k pro wich > simplified chinese > as default language. Dont steal threads by just answering to an unrelated e-mail from the list! To your question: afaic the win32 port currently has some issues with the right support of unicode. You may check your documentation. Do you think its a good idea to actually name objects in the database in a foreign encoding? I'd stick to english language names here because it makes chatting about problems/hints much more easy on mailinglists. -- Tino Wildenhain <tino@wildenhain.de>
> i want to list non-system tables with psql and get the following error. any > alternatives? Thanks. > > EPost-# \dt > ERROR: invalid byte sequence for encoding "UNICODE": 0xed > > my database used UNICODE as the encoding. and the OS is win2k pro wich > simplified chinese > as default language. There is a character (0xED) that doesn't seem to be Unicode compliant. Maybe you have a tablename that uses another encoding or is simply fscked up. I had those problems with some German character, after switching to UTF8 encoding. I solved it with a pg_dump of the DB that I converted with iconv to UTF and restored it into the cluster. I have no idea if iconv exists for Microsoft OSes, but there should be alternatives to convert encoding to UTF.
I use a database with UNIBASE encoding too. Writing strings in unicode with german vovels does not work. We access the database via the ODBC driver.
What kind of documentation do you mean with You may check your documentation ?
Best regards,
Josef Springer
Tino Wildenhain wrote:
What kind of documentation do you mean with You may check your documentation ?
Best regards,
Josef Springer
Tino Wildenhain wrote:
Am Montag, den 01.08.2005, 16:19 -0600 schrieb YL:i want to list non-system tables with psql and get the following error. any
alternatives? Thanks.
EPost-# \dt
ERROR: invalid byte sequence for encoding "UNICODE": 0xed
my database used UNICODE as the encoding. and the OS is win2k pro wich
simplified chinese
as default language.
Dont steal threads by just answering to an unrelated e-mail
from the list!
To your question: afaic the win32 port currently has some issues
with the right support of unicode. You may check your documentation.
Do you think its a good idea to actually name objects in the database
in a foreign encoding? I'd stick to english language names here because
it makes chatting about problems/hints much more easy on mailinglists.
--
mit freundlichen Grüssen,
Josef Springer
(Geschäftsleitung)
-- the software company --
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
Tel. | ++49(0)89 600 6920 |
Fax | ++49(0)89 600 69220 |
mailto | Josef.Springer@joops.com |
Website | http://www.joops.com |
Attachment
Mart�n Marqu�s wrote: > What happend with pgmonitor? Uh, it is at: http://gborg.postgresql.org/project/pgmonitor/projdisplay.php -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
El Lun 08 Ago 2005 18:29, Bruce Momjian escribió: > Martín Marqués wrote: > > What happend with pgmonitor? > > Uh, it is at: > > http://gborg.postgresql.org/project/pgmonitor/projdisplay.php Yes, I know, but it looks like unsupported, and with the last Debian update from 7.4 to 8.0 it got uninstalled. Could it be because of the drop of Tk support? -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; --------------------------------------------------------- Martín Marqués | Programador, DBA Centro de Telemática | Administrador Universidad Nacional del Litoral ---------------------------------------------------------