Print Thread
Page 1 of 2 1 2
Function Compare to saves always as ANSI
#64533 04/04/23 06:29 AM
Joined: May 2000
Posts: 15
Chelm, Poland
A
AdamG Offline OP
Member
OP Offline
Member
A
Joined: May 2000
Posts: 15
Chelm, Poland
Hi,
my database is AL32UTF8, I have in preferences/Files/Format/Encoding -> Always UTF8, but when I use function to compare my edit window to current database source both files ( Editor.pcf and Database.pcf ) are saved with ANSI encoding so I have all characters which are not in my ANSI codepage showed as questionmarks.

Is it a bug, or there is some other setting I am missing?

Regards,
Adam

Re: Function Compare to saves always as ANSI
AdamG #64534 04/04/23 06:35 AM
Joined: Jan 2006
Posts: 66
Lithuania
Member
Online Confused
Member
Joined: Jan 2006
Posts: 66
Lithuania
Hi,
How about „preferences/Oracle/Options/Unicode enabled“?


Dalius
Re: Function Compare to saves always as ANSI
AdamG #64535 04/04/23 06:38 AM
Joined: May 2000
Posts: 15
Chelm, Poland
A
AdamG Offline OP
Member
OP Offline
Member
A
Joined: May 2000
Posts: 15
Chelm, Poland
That's enabled. I don't have any problems with opening files which are UTF8, typing and compiling the code. All works, and UTF8 characters are not lost. It happens only when files are saved for external comparation.

Re: Function Compare to saves always as ANSI
AdamG #64537 04/04/23 08:52 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
Which PL/SQL Developer version are you using?


Marco Kalter
Allround Automations
Re: Function Compare to saves always as ANSI
AdamG #64538 04/04/23 01:59 PM
Joined: May 2000
Posts: 15
Chelm, Poland
A
AdamG Offline OP
Member
OP Offline
Member
A
Joined: May 2000
Posts: 15
Chelm, Poland
PL/SQL Developer
Version 15.0.3.2059 (64 bit)
263.142721 - 10 user license
Service Contract: 2023-06-01
Style: Office Dark
Windows 11 Build 22621
pl-PL(1045)/Polski (Polska)

Re: Function Compare to saves always as ANSI
AdamG #64539 04/04/23 02:02 PM
Joined: May 2000
Posts: 15
Chelm, Poland
A
AdamG Offline OP
Member
OP Offline
Member
A
Joined: May 2000
Posts: 15
Chelm, Poland
Aditionally I have NLS_LANG=polish_poland.ee8mswin1250 for my ansi codepage to oracle
and in %APPDATA%\PLSQL Developer 15\params.ini i have nls_lang=polish_poland.utf8 to compile in utf8

Re: Function Compare to saves always as ANSI
AdamG #64540 04/05/23 08:14 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
Can you send me a screenshot of your Preferences > Files > Format page?


Marco Kalter
Allround Automations
Re: Function Compare to saves always as ANSI
Marco Kalter #64541 04/07/23 08:34 AM
Joined: May 2000
Posts: 15
Chelm, Poland
A
AdamG Offline OP
Member
OP Offline
Member
A
Joined: May 2000
Posts: 15
Chelm, Poland
My preferences attached

Attached Files
9462tCpEDB.png (40.19 KB, 36 downloads)
Re: Function Compare to saves always as ANSI
AdamG #64543 04/10/23 12:47 PM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
This seems to work fine. Can you send me a screenshot if the incorrect comparison?


Marco Kalter
Allround Automations
Re: Function Compare to saves always as ANSI
AdamG #64546 04/11/23 09:42 AM
Joined: May 2000
Posts: 15
Chelm, Poland
A
AdamG Offline OP
Member
OP Offline
Member
A
Joined: May 2000
Posts: 15
Chelm, Poland
I have my package body saved to file and when just after save I use Compare to -> Current file... I have Window.pcf saved as ANSI not UTF-8. See on screenshot

Attached Files
GG0OzgWIVs.png (61.04 KB, 23 downloads)
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.045s Queries: 17 (0.016s) Memory: 2.5569 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-04 07:22:48 UTC
Valid HTML 5 and Valid CSS