Print Thread
Page 1 of 2 1 2
OracleScript not detect ANSI text
#48156 11/09/13 01:13 PM
Joined: Sep 2013
Posts: 14
S
C
Member
OP Offline
Member
C
Joined: Sep 2013
Posts: 14
S
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'

Re: OracleScript not detect ANSI text
Consinco #48160 11/11/13 10:48 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
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.


Marco Kalter
Allround Automations
Re: OracleScript not detect ANSI text
Marco Kalter #48164 11/11/13 07:46 PM
Joined: Sep 2013
Posts: 14
S
C
Member
OP Offline
Member
C
Joined: Sep 2013
Posts: 14
S
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.

Last edited by Consinco; 11/11/13 07:51 PM.
Re: OracleScript not detect ANSI text
Consinco #48168 11/12/13 10:58 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
Can you also let me know the character set of the database?


Marco Kalter
Allround Automations
Re: OracleScript not detect ANSI text
Marco Kalter #48170 11/12/13 11:52 AM
Joined: Sep 2013
Posts: 14
S
C
Member
OP Offline
Member
C
Joined: Sep 2013
Posts: 14
S
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

Last edited by Consinco; 11/12/13 12:10 PM.
Re: OracleScript not detect ANSI text
Consinco #48176 11/13/13 12:13 PM
Joined: Sep 2013
Posts: 14
S
C
Member
OP Offline
Member
C
Joined: Sep 2013
Posts: 14
S
Any suggestions?

Re: OracleScript not detect ANSI text
Consinco #48181 11/14/13 10:31 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
These are session parameters. Can you let me know the character set that the database was created with?

Code
select value from nls_database_parameters
where parameter = 'NLS_CHARACTERSET'


Marco Kalter
Allround Automations
Re: OracleScript not detect ANSI text
Marco Kalter #48182 11/14/13 10:36 AM
Joined: Sep 2013
Posts: 14
S
C
Member
OP Offline
Member
C
Joined: Sep 2013
Posts: 14
S
Had already posted

NLS_CHARACTERSET WE8MSWIN1252

Only occurs when I use OracleScript when using OracleQuery works normally!

Last edited by Consinco; 11/14/13 10:38 AM.
Re: OracleScript not detect ANSI text
Consinco #48211 11/20/13 01:54 PM
Joined: Sep 2013
Posts: 14
S
C
Member
OP Offline
Member
C
Joined: Sep 2013
Posts: 14
S
Can you help me with this? Tks.

Re: OracleScript not detect ANSI text
Marco Kalter #48216 11/22/13 10:50 AM
Joined: Sep 2013
Posts: 14
S
C
Member
OP Offline
Member
C
Joined: Sep 2013
Posts: 14
S
Any tips please?

Page 1 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.040s Queries: 16 (0.010s) Memory: 2.5567 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-05 14:55:06 UTC
Valid HTML 5 and Valid CSS