On May 11, 2007, at 12:52, Ivan Prenosil wrote:

> The "group by" is important here (and the connect charset is
> important just indirectly).

Yes, I see this too:

> Try these
> SELECT ((EXTRACT(YEAR FROM CURRENT_DATE) || _UTF8'')) FROM rdb
> $database;

Works.

> SELECT ((EXTRACT(YEAR FROM CURRENT_DATE) || _UTF8'')) FROM rdb
> $database GROUP BY 1;

Doesn't work.

> SELECT ((EXTRACT(YEAR FROM CURRENT_DATE) || _WIN1250'')) FROM rdb
> $database GROUP BY 1;

Works.
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html