Character Set

[binfch]

Hi there

Sorry I am sure this question has already been asked x-times but still I can not find any infos...

I am using D7 with the latest DOA to access an Oracle 10.2 DB.

-> In PL/SQL Developer text looks OK (French

 

[Marco Kalter]

What exactly is the problem?

 

[binfch]

-> Looks like the post got truncated somehow! Here it is again:

Hi there

Sorry I am sure this question has already been asked x-times but still I can not find any infos...

I am using D7 with the latest DOA to access an Oracle 10.2 DB.

In PL/SQL Developer texts looks OK (French & German special umlauts for example). However in my D7 prg. they are displayed wrong.

-> Where can I configure this in DOA?

Here's the code I am using:

with OracleQueryStatus do begin
  SetComplexVariable('O_MANUF_REFCURSOR', OracleQueryStatusManuf);
  Execute;
  if GetVariable('RESULT') = 0 then begin
    MfArray := TMfArray.Create;
    with OracleQueryStatusManuf do begin
      Execute;
      while not Eof do begin
        MfRecord := TMfRecord.Create;
        MfRecord.Manufacturer := Field('MANUFACTURER');
ShowMessage(Field('MANUFACTURER'));
        MfRecord.Status := Field('STATUS');
        MfArray.Add(MfRecord);
        Next;
      end;
    end;
  end;
end;

and here's the DB configuration:

"PARAMETER";"VALUE"
"NLS_CALENDAR";"GREGORIAN"
"NLS_CHARACTERSET";"AL32UTF8"
"NLS_COMP";"BINARY"
"NLS_CURRENCY";"SFr."
"NLS_DATE_FORMAT";"DD.MM.RR"
"NLS_DATE_LANGUAGE";"GERMAN"
"NLS_DUAL_CURRENCY";"SF"
"NLS_ISO_CURRENCY";"SWITZERLAND"
"NLS_LANGUAGE";"GERMAN"
"NLS_LENGTH_SEMANTICS";"BYTE"
"NLS_NCHAR_CHARACTERSET";"AL16UTF16"
"NLS_NCHAR_CONV_EXCP";"FALSE"
"NLS_NUMERIC_CHARACTERS";".'"
"NLS_RDBMS_VERSION";"10.2.0.4.0"
"NLS_SORT";"GERMAN"
"NLS_TERRITORY";"SWITZERLAND"
"NLS_TIME_FORMAT";"HH24:MI:SSXFF"
"NLS_TIMESTAMP_FORMAT";"DD.MM.RR HH24:MI:SSXFF"
"NLS_TIMESTAMP_TZ_FORMAT";"DD.MM.RR HH24:MI:SSXFF TZR"
"NLS_TIME_TZ_FORMAT";"HH24:MI:SSXFF TZR"

Thx & cheers,
Peter

 

[Marco Kalter]

I see that you have an UTF8 database. With Delphi 7 you should probably set Oracle.NoUnicodeSupport to True, so that all Unicode characters are converted to the client character set. Alternatively you can use Unicode controls and process all data as Unicode.

 

[binfch]

"Oracle.NoUnicodeSupport" works perfectly!

Thx,
P.