Modificacion de palabras con tilde al compilar

[ManuCuerda]

Hola,

Tengo un problema y es que al compilar, las palabras con tilde, aunque en el editor ponga la palabra bien, por ejemplo: 'funcion' (con tilde), al compilar me cambia la vocal con tilde por un caracter especial, por ejemplo: 'funci�n'.

En Preferences--> Files--> Format tengo marcardo 'Always UTF8' pero sigue funcionando igual.

 

[Marco Kalter]

Can you post your message in English?

 

[ManuCuerda]

Hello,

I have a problem and is that when compiling, the words with accent, although in the editor put the word well, for example: 'function' (with tilde), when compiling I change the vowel with accent by a special character, for example: 'function'.
You can only put words with tilde in comments, but the compiler modifies that word.

In Preferences -> Files -> Format I have marked 'Always UTF8' but it still works badly.

Somebody could help me?

Thank you so much.

 

[Marco Kalter]

Maybe this is an environment problem. Can you start PL/SQL Developer without connecting, go to Help > Support Info and send me the text from the "Info" tab page?

 

[ManuCuerda]

Hi Marco,

Attach this info:

PL/SQL Developer
Version 12.0.7.1837 (32 bit)
01.117917 - 10 user license
Service Contract: 01/02/2019
Windows 10 (64-bit) Build 15063

Physical memory : 16.658.988 kB (7.617.196 available)
Paging file : 19.149.356 kB (8.292.064 available)
Virtual memory : 2.097.024 kB (1.819.940 available)

Parameters
C:\Program Files (x86)\PLSQL Developer 12\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Users\manuel.delacuerda\AppData\Roaming\PLSQL Developer 12\Preferences\default\Default.ini
C:\Users\manuel.delacuerda\AppData\Roaming\PLSQL Developer 12\Preferences\manuel.delacuerda\default.ini

License File
C:\Users\manuel.delacuerda\AppData\Roaming\PLSQL Developer 12\aalf.dat

Debug file
C:\Users\manuel.delacuerda\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
6CASE
ATLDES
ATLDRIVE
ATLDWEB
ATLHTX
...

Homes
OraClient11g_home1 (C:\app\manuel.delacuerda\product\11.2.0\client_1)

DLLs
C:\app\manuel.delacuerda\product\11.2.0\client_1\oci.dll

TNS File
C:\Oracle\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: C:\app\manuel.delacuerda\product\11.2.0\client_1\oci.dll
OCI: version 11.1 (11.2.0.1.0)

Process
Working Set = 131.960.832
Memory = 35.019.684
GDI Objects = 671
User Objects = 474
Handles = 360

Monitors
PixelsPerInch = 96

Id = 0
Primary = False
Handle = 65539
Left = -1366
Top = 0
Width = 1366
Height = 768

Id = 1
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080

MainFormOnTaskbar = False

 

[Marco Kalter]

My apologies, I mentioned "Can you start PL/SQL Developer without connecting". This should have been "Can you start PL/SQL Developer and connect to the database".

Can you do this and send the information again?

 

[ManuCuerda]

Ok Marco, no problem.

Attach:
PL/SQL Developer
Version 12.0.7.1837 (32 bit)
01.117917 - 10 user license
Service Contract: 01/02/2019
Windows 10 (64-bit) Build 15063

Physical memory : 16.658.988 kB (7.496.936 available)
Paging file : 19.149.356 kB (8.164.828 available)
Virtual memory : 2.097.024 kB (1.593.916 available)

Parameters
C:\Program Files (x86)\PLSQL Developer 12\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Users\manuel.delacuerda\AppData\Roaming\PLSQL Developer 12\Preferences\default\Default.ini
C:\Users\manuel.delacuerda\AppData\Roaming\PLSQL Developer 12\Preferences\manuel.delacuerda\default.ini

License File
C:\Users\manuel.delacuerda\AppData\Roaming\PLSQL Developer 12\aalf.dat

Debug file
C:\Users\manuel.delacuerda\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
6CASE
ATLDES
ATLDRIVE
ATLDWEB
ATLHTX
...

Homes
OraClient11g_home1 (C:\app\manuel.delacuerda\product\11.2.0\client_1)

DLLs
C:\app\manuel.delacuerda\product\11.2.0\client_1\oci.dll

TNS File
C:\Oracle\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: C:\app\manuel.delacuerda\product\11.2.0\client_1\oci.dll
OCI: version 11.1 (11.2.0.1.0)
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

Character Sets
Character size: 3 byte(s)
CharSetID: 871
NCharSetID: 2000
Unicode Support: True
NLS_LANG: SPANISH_SPAIN.WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: UTF8

Process
Working Set = 87.281.664
Memory = 55.631.648
GDI Objects = 877
User Objects = 955
Handles = 756

Monitors
PixelsPerInch = 96

Id = 0
Primary = False
Handle = 65539
Left = -1366
Top = 0
Width = 1366
Height = 768

Id = 1
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080

MainFormOnTaskbar = False

Regards.

 

[Marco Kalter]

I see that your client character set is WE8MSWIN1252, and the database character set is UTF8. This should work correctly for Spanish characters. I tested this with an "n" with a tilde in procedure code, and it works fine.

Did you try this as well? Can you send me 2 screenshots by e-mail (before and after) to demonstrate the issue?

 

[ManuCuerda]

Hi Marco,

Right now I'm sending you the email. Thank you.