Re: Determine Client Encoding
От | Leonardo M. Ramé |
---|---|
Тема | Re: Determine Client Encoding |
Дата | |
Msg-id | 20140226151425.GB6199@leonardo-laptop обсуждение исходный текст |
Ответ на | Re: Determine Client Encoding (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
On 2014-02-26 09:48:12 -0500, Tom Lane wrote: > Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= <l.rame@griensu.com> writes: > > Hi, we found characters with different enconding in our database. As our > > system is accessed by many PCs I would like to know if it's possible to > > know the encoding of each connection, without going to each PC to check > > its connection string. > > If you mean can one session identify the client_encoding of another > session, no; that information isn't exposed anyplace. Within a session, > you can of course use "show client_encoding" or various equivalent > syntaxes. > > Note that when you have encoding problems, as often as not the issue > is that the data the client is sending isn't really in the encoding > its client_encoding setting claims. So even if you could find that > out remotely, it probably wouldn't help localize the issue very well. > > regards, tom lane Thanks Tom, let me try to understand what you said. For example if client_encoding is set to "win1252", but the user does a copy-paste from MsWord (usually they do this), characters could have been sent in utf8 ?. If this is the case, the insert/update is done, but cannot be read from another client. Right?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877
В списке pgsql-general по дате отправления: