Skip site navigation (1) Skip section navigation (2)

Re: psqlODBC-Driver Test / text fields

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Ludek Finstrle" <luf(at)pzkagis(dot)cz>
Cc: "Johann Zuschlag" <zuschlag2(at)online(dot)de>,"Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: psqlODBC-Driver Test / text fields
Date: 2006-03-29 15:34:52
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C98F3@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
 

> -----Original Message-----
> From: Ludek Finstrle [mailto:luf(at)pzkagis(dot)cz] 
> Sent: 29 March 2006 16:23
> To: Dave Page
> Cc: Ludek Finstrle; Johann Zuschlag; Hiroshi Inoue; 
> pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] psqlODBC-Driver Test / text fields
> 
> Let's try read and it's ancestor:
> http://archives.postgresql.org/pgsql-odbc/2006-03/msg00188.php

I'm not sure I understand that that test is actually valid anyway. Consider the test query:

select name from kunde where name >= 'ö';

If 'ö' is 'ö', then isn't the query above mixing single and a multibyte encoding? Ie. It should all be single byte - e.g.

select name from kunde where name >= 'ö' order by name asc;

Or all multibyte (displayed byte by byte) whatever that results in:

s*e*l*e*c*t* *n*a*m*e* *f*r*o*m* *k*u*n*d*e* *w*h*e*r*e* *n*a*m*e* *>*=* *'*ö'*;*

Of course, we all know how well I grok encoding issues :-)

Regards, Dave.

Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-03-29 15:35:19
Subject: Re: psqlODBC-Driver Test / text fields
Previous:From: Ludek FinstrleDate: 2006-03-29 15:22:42
Subject: Re: psqlODBC-Driver Test / text fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group