OracleScript not detect ANSI text, to run the update the accents of the texts are exchanged, how can I solve?
AListScript.LoadFromFile('c:\atu.pdc');
AListScript.DefaultEncoding := TEncoding.ANSI;
OraScript := TOracleSession.Create(nil);
OraScript.Session := OracleSession;
OraScript.ScanVariables := False;
OraScript.OutputOptions := [ooError];
OraScript.Lines.Assign(AListScript); // -> AListScript ANSI
OraScript.Execute;
Result:
'Redução não exportada'
Can you let me know the NLS_LANG for your Oracle Session? It may be that the ANSI characters do not match the character set of the NLS_LANG.
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
This only happens when I run by TOracleScript. example create a package, procedure or function that contains text with an accent.
Can you also let me know the character set of the database?
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
These are session parameters. Can you let me know the character set that the database was created with?
select value from nls_database_parameters
where parameter = 'NLS_CHARACTERSET'
Had already posted
NLS_CHARACTERSET WE8MSWIN1252
Only occurs when I use OracleScript when using OracleQuery works normally!
Can you help me with this? Tks.
We can;t reproduce this. Can you send me a little demo project?
Compile in XE3 solve the problem, have not had time to investigate the issue in XE5.
Thanks again!