Re: More Code Page wierdness

Simon Riggs wrote:

>On Tue, 2005-01-11 at 11:49 -0500, Tom Lane wrote:
>  
>
>>"Magnus Hagander" <[email protected]> writes:
>>    
>>
>>>I'm having trouble seeing why '*' would have a different value in
>>>different codepages. I'm wondering if we're going down the wrong road
>>>completely here?
>>>      
>>>
>>That was what was bothering me too.  It's hard to interpret Simon's
>>report in another way though.
>>    
>>
>
>I'm open to other suggestions as to why "*" would not work, when other
>explicit settings do.... 
>
>...especially something that gets fixed by changing the code page.
>
>I do agree that its hard to see whats going on... I spent 4 hrs on a *
>  
>


Can you hex dump a file edited with various code pages in place and see 
what different values an asterisk gets? That should settle the question, 
shouldn't it?

cheers

andrew

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match