Delphi 2007
ElevateDB v1.06b1 Unicode
Table Dict_Deu was migrated from DBISAM v3

Table Dict_Deu includes a column "Term"
which is defined as: VarChar, Length(100), Collation=DEU

These SQL examples were all done in ElevateDB Manager (Unicode), so actually
the Delphi version is irrelevant.

SELECT Term FROM Dict_Deu
This SQL returns a list of German terms, for example:
 begießen
 Bonito
 Fasanenbraten
 gebratene Zucchini

SELECT UPPER(Term) AS UpperCase_Term FROM Dict_Deu
I would expect this SQL to return the same list in uppercase:
 BEGIESSEN
 BONITO
 FASANENBRATEN
 GEBRATENE ZUCCHINI

But what is actually returned is as follows:
 Bauernhof
 Drache
 marinierter Aa
 vatermörderisch

The result set differs, it is not in upper case, and the third term ('marinierter Aal')
has been
truncated at the final character.

The following SQL perhaps indicates better what is going wrong:
SELECT                
 LOWER(Term) as LowerTerm,
 Term
FROM Dict_Deu

The result set returns two completely different lists of German terms in column
"LowerTerm" and "Term":
 Bauernhof  +  begießen
 Drache  +  Bonito
 Marinierter Aa  +  Fasanenbraten
 vatermörderisch  +  gebratene Zucchini

1. Must I accept that the UPPER and LOWER operators do not apply in the Unicode version?
2. Or am I querying a table that was converted from DBISAM v3 with the wrong migrator?  
3. Or is this simply a bug?

Many thanks for any ideas.

Dan

Dan,

<< These SQL examples were all done in ElevateDB Manager (Unicode), so
actually the Delphi version is irrelevant. >>

Could you send me the table files (.edbtbl, .edbidx, .edbblb) and the
database catalog file (edbdatabase.edbcat) that you're using along with the
complete query ?  I also need to know if you are setting the Request
Sensitive check box or not when executing the query in the EDB Manager.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< Could you send me the table files (.edbtbl, .edbidx, .edbblb) and the
database catalog file (edbdatabase.edbcat) that you're using along with the
complete query ? >>

Sure, but it won't be until Monday. It's a computer-free weekend coming up...

<<  I also need to know if you are setting the Request Sensitive check box
or not when executing the query in the EDB Manager. >>

The "Request Sensitive" box was left unchecked for these queries.

Cheers,
Dan

Tim,

<< Could you send me the table files (.edbtbl, .edbidx, .edbblb) and the
database catalog file (edbdatabase.edbcat) that you're using along with the
complete query ? >>

I have been trying to upload a zip file to the binaries newsgroup, but I get this error:
"The connection to the server was reset while the page was loading."

Any advice?

Thanks,
Dan

Dan,

<< I have been trying to upload a zip file to the binaries newsgroup, but I
get this error: "The connection to the server was reset while the page was
loading." >>

Could you just email me the .zip file ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

I have emailed to you a sample EDB table and SQL file to reproduce this problem
in EDB v1.06 Build 1.

Regards,
Dan

Dan,

<< I have emailed to you a sample EDB table and SQL file to reproduce this
problem in EDB v1.06 Build 1. >>

Thanks.  Per email, this is already fixed:

http://www.elevatesoft.com/scripts/incident.dll?action=viewaddr&category=edb&release=1.07&type=f&incident=2517

--
Tim Young
Elevate Software
www.elevatesoft.com