Re: Encoding using the Frontend/Backend Protocol TCP/IP

From: Kovalevski Andrei <kovalevski(dot)andrei(at)gmail(dot)com>
To: Raimon Fernandez <coder(at)montx(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Encoding using the Frontend/Backend Protocol TCP/IP
Date: 2009-11-19 20:21:40
Message-ID: 4B05A8D4.7020500@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

Hi,

the string is ok, but the problem is inside the message. The length of
the message is incorrect:

your message:

51000000*46*557064617465207472616E73616374696F6E7320736574206465736372697074696F6E3D27546573742056616C75657364C387272077686572652069643D313133

it should be:

51000000*45*557064617465207472616E73616374696F6E7320736574206465736372697074696F6E3D27546573742056616C75657364C387272077686572652069643D313133

Raimon Fernandez wrote:
> On 19/11/2009, at 18:13, Raimon Fernandez wrote:
>
>
>> On 19/11/2009, at 17:27, Kovalevski Andrei wrote:
>>
>>
>>> Hi
>>>
>>> could it be that you have errors in your UTF8 string? For example you might use UTF16 encoding, it can explain why some characters force errors but others are not.
>>>
>> It only happens with values like àéïçñ I think UTF8 can handle this ...
>>
>
>
> yes, It can handle it ...
>
> if I send the decoding by hand in a very simple update, it works, so there's something with UTF8 conversion that dosn't work ...
>
> for example, instead of sending Ç i send their equivalent in UTF8 &HC3+&H87 and it works ...
>
> thanks,
>
> regards,
>
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2009-11-19 20:30:25 Re: Possible bug with array_agg
Previous Message araza 2009-11-19 20:05:03 Issues with Redhat 4 Postgresql 8.4 and support of libxml

Browse pgsql-interfaces by date

  From Date Subject
Next Message Raimon Fernandez 2009-11-19 21:37:58 Re: Encoding using the Frontend/Backend Protocol TCP/IP
Previous Message Raimon Fernandez 2009-11-19 18:01:53 Re: Encoding using the Frontend/Backend Protocol TCP/IP