View Single Post

   
  #10 (permalink)  
Old 04-09-2008, 10:41 AM
Eric Faulhaber
 
Posts: n/a
Default Re: UTF8 conversion differences from v8.1.3 to v8.1.4

Tom Lane wrote:
> Martijn van Oosterhout <kleptog@svana.org> writes:
>> The fact is that if you're using binary format paramaters and output
>> you can put embedded nulls into strings and get them back out.

>
> Not any more ;-)
>


OK, but now that this "feature" has been removed in 8.1.4, how is this
supposed to be handled, given that we don't control what string data
we're handed? How does psql deal with it?

>> By changing a
>> few strcmps to memcmps you can get sane behaviour for sorting a several
>> other operations.

>
> Given the lack of "memcoll", that proposal isn't going to fly ...
> at least not until we replace all the locale support code with something
> else (that hopefully will be null-clean).
>
> regards, tom lane


Thanks,
Eric

---------------------------(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

Reply With Quote