Re: information_schema.columns changes needed for OLEDB - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: information_schema.columns changes needed for OLEDB
Date
Msg-id 200907062137.53007.peter_e@gmx.net
Whole thread Raw
In response to information_schema.columns changes needed for OLEDB  (Konstantin Izmailov <kizmailov@gmail.com>)
Responses Re: information_schema.columns changes needed for OLEDB
List pgsql-hackers
On Friday 22 May 2009 18:27:01 Konstantin Izmailov wrote:
> 3. character_octet_length should always be double of
> character_maximum_length (due to Unicode character size on Windows which is
> 2).

I have the attached patch that would make character_octet_length the product 
of character_octet_length and the maximum octet length of a single character 
in the selected server encoding.  So for UTF-8, this would be factor 4.  This 
doesn't exactly correspond to the behavior that you expect, but I think it's 
more correct overall anyway.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )
Next
From: Tom Lane
Date:
Subject: Re: information_schema.columns changes needed for OLEDB