Unicode Field or Field Alias names?

MarkF · Post by **MarkF** » Wed 24 Jun 2009 12:44

I've noticed with the latest build 6.80.0.47 that FieldName seems to return an ansi string (or that an ansi conversion happens somewhere.) I don't remember it doing that in earlier versions (although it's possible that I just didn't notice it.) Should this return a unicode string properly? I'm using OCIUnicode = True btw.

Code: Select all

  OraQuery.SQL.Text := 'select ''αβγδεζηθ1'' from dual';
  OraQuery.Execute;
  for i := 0 to OraQuery.FieldCount - 1 do
    Memo1.Lines.Add(OraQuery.Fields[i].FieldName);

Returns:
'ΑΒΓΔΕΖΗΘ1'
instead of:
αβγδεζηθ1

Thanks for any help!

-Mark

Plash · Post by **Plash** » Wed 24 Jun 2009 12:53

Oracle just converts the field name to upper case.

MarkF · Post by **MarkF** » Wed 24 Jun 2009 16:48

Oops! Thanks for pointing that out! I just tested:

select 'αβγδεζηθ1' "αβγδεζηθ1" from dual;

and it works perfectly. Sorry for the false alarm!

-Mark