Internalization question

Posted by OctavioOlguin on 16-Sep-2015 18:57

Good Day..

I have this problem...  I installed a boot camp  macbook pro to access the corporation database, by client-server.  Other stations have worked ok, for years, but this newly station, can't work as for this windows 7 session, the progress instance finds that 

é = e

ñ = n

but the other stations find them (correctly) different.  

Database and client are installed as  ISO 8859 Basic-Basic character set.

The localisation on the "virtual" windows on mac is Latin - Mexico as rest of clients.

But for some reason, the client running on bootcamp, can't differentiate ñ from n, as the rest do.  It considers them to be equal, which is not correct in this case..

I think it is something local to the windows on mac?   The regional configuration of this instance is equal to other client-server clients on network.

TIA.

Jorge olguin

OpenEdge Development - Forum
Posted by Libor Laubacher on 17-Sep-2015 04:10

> I think it is something local to the windows on mac?

It is related to -cpcoll which is set to basic. Set it to -cpcoll Spanish9 (with your prowin32 session).

All Replies

Posted by TheMadDBA on 16-Sep-2015 19:09

When you say they are the same... do you mean that a Progress EQ function shows them as the same or that the keyboard doesn't type them in properly?

Run the code from this KB knowledgebase.progress.com/.../000026036 on a machine that is working and the mac and see if there are any differences in the IN18N section.

Posted by OctavioOlguin on 16-Sep-2015 19:34

I'll check..

The problem as I missed to explain is that the unique key of a temp- table won't  allow "CALNO" value when "CALÑO" was already present on the temp-table I´m loading..

Posted by OctavioOlguin on 16-Sep-2015 19:41

I've run the procedure on a laptop windows 7, and on mac bootcam windows 7 and this are the results.

First the one from the laptop, which works as I would expect:

Date: 16/09/15   Time: 19:30:50
Operating System: WIN32
Machine name: OCTAVIO-PC
Display type: GUI
Screen Virtual Width: 1280
Screen Virtual Height: 800


Progress Version: 11.5NO PATCH INSTALLED


ORACLE_SID       : ?
ORACLE_HOME      : ?
NLS_LANG         : ?
NLS_CHARACTER_SET: ?


Session startup parameters: 
-pf C:\Progress\OpenEdge\startup.pf,-cpinternal ISO8859-1,-cpstream ISO8859-1,-cpcoll Basic,-cpcase Basic,-d dmy,-numsep 44,-numdec 46,(end .pf),-p _desk.p


<< IN18N >>


Windows codepage: 1252

cpinternal: ISO8859-1
cpstream  : ISO8859-1
cpprint   : ISO8859-1
cpcase    : Basic
cpcoll    : Basic
cplog     : ISO8859-1
cprcodein : ?
cprcodeout: ?
cpterm    : ISO8859-1


<< DATABASES >>:          0


<<FONT REPORT 1>>


SESSION:PIXELS-PER-ROW => 21
SESSION:PIXELS-PER-COL => 5
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(0)) => 14
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",0) / 20  => 7
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",0)  => 140
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(1)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",1) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",1)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(2)) => 14
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",2) / 20  => 7
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",2)  => 140
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(3)) => 14
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",3) / 20  => 7
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",3)  => 140
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(4)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",4) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",4)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(5)) => 16
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",5) / 20  => 7
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",5)  => 140
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(6)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",6) / 20  => 7.05
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",6)  => 141
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(7)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",7) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",7)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(8)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",8) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",8)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(9)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",9) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",9)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(10)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",10) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",10)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(11)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",11) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",11)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(12)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",12) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",12)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(13)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",13) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",13)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(14)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",14) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",14)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(15)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",15) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",15)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(16)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",16) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",16)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(17)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",17) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",17)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(18)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",18) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",18)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(19)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",19) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",19)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(20)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",20) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",20)  => 120



DefaultFixedFont   : Courier New, size=8
DefaultFont        : MS Sans Serif, size=8
DefaultV6UpdateFont: ?



font0  => Courier New, size=8
font1  => MS Sans Serif, size=8
font2  => Courier New, size=8
font3  => Courier New, size=8
font4  => MS Sans Serif, size=8
font5  => MS Sans Serif, size=10
font6  => MS Sans Serif, size=8, bold
font7  => MS Sans Serif, size=8
font8  => ?
font9  => ?
font10  => ?
font11  => ?
font12  => ?
font13  => ?
font14  => ?
font15  => ?
font16  => ?
font17  => ?
font18  => ?
font19  => ?
font20  => ?


SESSION ATTRIBUTES:  
     : ERROR retriving the value
     APPL-ALERT-BOXES: no
     ASYNC-REQUEST-COUNT: 0
     BASE-ADE: ?
     BATCH-MODE: no
     CHARSET: ISO8859-1
     CLIENT-TYPE: 4GLCLIENT
     CONTEXT-HELP-FILE: ?
     CPCASE: Basic
     CPCOLL: Basic
     CPLOG: ISO8859-1
     CPPRINT: ISO8859-1
     CPRCODEIN: ?
     CPRCODEOUT: ?
     CPSTREAM: ISO8859-1
     CPTERM: ISO8859-1
     CURRENT-REQUEST-INFO: ?
     CURRENT-RESPONSE-INFO: ?
     DATA-ENTRY-RETURN: no
     DATE-FORMAT: dmy
     DEBUG-ALERT: no
     DISPLAY-TIMEZONE: ?
     DISPLAY-TYPE: GUI
     DOTNET-CLR-LOADED: yes
     ERROR-STACK-TRACE: no
     EXECUTION-LOG: no
     EXPORT: no
     FIRST-ASYNC-REQUEST: ?
     FIRST-BUFFER: ?
     FIRST-CHILD: 1045
     FIRST-DATA-SOURCE: ?
     FIRST-DATASET: ?
     FIRST-FORM: Progress.Windows.FormProxy
     FIRST-OBJECT: ?
     FIRST-PROCEDURE: ?
     FIRST-QUERY: ?
     FIRST-SERVER: ?
     FIRST-SERVER-SOCKET: ?
     FIRST-SOCKET: ?
     FRAME-SPACING: 21
     GET-PRINTERS: Microsoft XPS Document Writer,Fax,Enviar a OneNote 2010
     GET-WAIT-STATE: 
     HANDLE: 20
     HEIGHT-CHARS: 38.1
     HEIGHT-PIXELS: 800
     ICFPARAMETER: 
     IMMEDIATE-DISPLAY: no
     INHERIT-BGCOLOR: yes
     INHERIT-COLOR-MODE: 1
     INHERIT-FGCOLOR: yes
     INSTANTIATING-PROCEDURE: ?
     LAST-ASYNC-REQUEST: ?
     LAST-CHILD: 1018
     LAST-FORM: Progress.Windows.FormProxy
     LAST-OBJECT: ?
     LAST-PROCEDURE: ?
     LAST-SERVER: ?
     LAST-SERVER-SOCKET: ?
     LAST-SOCKET: ?
     LOCAL-VERSION-INFO: Progress.Lang.OEVersionInfo_1112
     MULTITASKING-INTERVAL: 0
     NUMERIC-DECIMAL-POINT: .
     NUMERIC-FORMAT: AMERICAN
     NUMERIC-SEPARATOR: ,
     OLE-INVOKE-LOCALE: 0
     OLE-NAMES-LOCALE: 1033
     PARAMETER: 
     PIXELS-PER-COLUMN: 5
     PIXELS-PER-ROW: 21
     PRINTER-CONTROL-HANDLE: 0
     PRINTER-HDC: 0
     PRINTER-NAME: Enviar a OneNote 2010
     PRINTER-PORT: nul:
     PROXY-PASSWORD: ?
     PROXY-USERID: ?
     REMOTE: no
     SCHEMA-CHANGE: 
     SERVER-CONNECTION-BOUND: no
     SERVER-CONNECTION-BOUND-REQUEST: no
     SERVER-CONNECTION-CONTEXT: 
     SERVER-CONNECTION-ID: 
     SERVER-OPERATING-MODE: 
     STARTUP-PARAMETERS: -pf C:\Progress\OpenEdge\startup.pf,-cpinternal ISO8859-1,-cpstream ISO8859-1,-cpcoll Basic,-cpcase Basic,-d dmy,-numsep 44,-numdec 46,(end .pf),-p _desk.p
     SUPER-PROCEDURES: 
     SUPPRESS-WARNINGS: no
     SUPPRESS-WARNINGS-LIST: 
     SYSTEM-ALERT-BOXES: yes
     TEMP-DIRECTORY: C:\OpenEdge\WRK\
     THREE-D: yes
     TIME-SOURCE: LOCAL
     TIMEZONE: ?
     TOOLTIPS: yes
     TYPE: PSEUDO-WIDGET
     V6DISPLAY: no
     WIDTH-CHARS: 256
     WIDTH-PIXELS: 1280
     WINDOW-SYSTEM: MS-WINXP
     WORK-AREA-HEIGHT-PIXELS: 760
     WORK-AREA-WIDTH-PIXELS: 1280
     WORK-AREA-X: 0
     WORK-AREA-Y: 0
     YEAR-OFFSET: 1950


and this is from the mac

Date: 16/09/15   Time: 19:36:10
Operating System: WIN32
Machine name: CISNEROS-PC
Display type: GUI
Screen Virtual Width: 1280
Screen Virtual Height: 800


Progress Version: 11.5NO PATCH INSTALLED


ORACLE_SID       : ?
ORACLE_HOME      : ?
NLS_LANG         : ?
NLS_CHARACTER_SET: ?


Session startup parameters: 
-pf C:\Progress\OpenEdge\startup.pf,-cpinternal ISO8859-1,-cpstream ISO8859-1,-cpcoll Basic,-cpcase Basic,-d dmy,-numsep 44,-numdec 46,(end .pf),-p _desk.p


<< IN18N >>


Windows codepage: 1252

cpinternal: ISO8859-1
cpstream  : ISO8859-1
cpprint   : ISO8859-1
cpcase    : Basic
cpcoll    : Basic
cplog     : ISO8859-1
cprcodein : ?
cprcodeout: ?
cpterm    : ISO8859-1


<< DATABASES >>:          0


<<FONT REPORT 1>>


SESSION:PIXELS-PER-ROW => 21
SESSION:PIXELS-PER-COL => 5
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(0)) => 14
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",0) / 20  => 7
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",0)  => 140
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(1)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",1) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",1)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(2)) => 14
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",2) / 20  => 7
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",2)  => 140
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(3)) => 14
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",3) / 20  => 7
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",3)  => 140
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(4)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",4) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",4)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(5)) => 16
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",5) / 20  => 7
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",5)  => 140
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(6)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",6) / 20  => 7.05
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",6)  => 141
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(7)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",7) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",7)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(8)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",8) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",8)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(9)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",9) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",9)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(10)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",10) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",10)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(11)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",11) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",11)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(12)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",12) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",12)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(13)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",13) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",13)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(14)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",14) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",14)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(15)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",15) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",15)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(16)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",16) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",16)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(17)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",17) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",17)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(18)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",18) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",18)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(19)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",19) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",19)  => 120
FONT-TABLE:GET-TEXT-HEIGHT-PIXELS(20)) => 13
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",20) / 20  => 6
FONT-TABLE:GET-TEXT-WIDTH-PIXELS("12345678901234567890",20)  => 120



DefaultFixedFont   : Courier New, size=8
DefaultFont        : MS Sans Serif, size=8
DefaultV6UpdateFont: ?



font0  => Courier New, size=8
font1  => MS Sans Serif, size=8
font2  => Courier New, size=8
font3  => Courier New, size=8
font4  => MS Sans Serif, size=8
font5  => MS Sans Serif, size=10
font6  => MS Sans Serif, size=8, bold
font7  => MS Sans Serif, size=8
font8  => ?
font9  => ?
font10  => ?
font11  => ?
font12  => ?
font13  => ?
font14  => ?
font15  => ?
font16  => ?
font17  => ?
font18  => ?
font19  => ?
font20  => ?


SESSION ATTRIBUTES:  
     : ERROR retriving the value
     APPL-ALERT-BOXES: no
     ASYNC-REQUEST-COUNT: 0
     BASE-ADE: ?
     BATCH-MODE: no
     CHARSET: ISO8859-1
     CLIENT-TYPE: 4GLCLIENT
     CONTEXT-HELP-FILE: ?
     CPCASE: Basic
     CPCOLL: Basic
     CPLOG: ISO8859-1
     CPPRINT: ISO8859-1
     CPRCODEIN: ?
     CPRCODEOUT: ?
     CPSTREAM: ISO8859-1
     CPTERM: ISO8859-1
     CURRENT-REQUEST-INFO: ?
     CURRENT-RESPONSE-INFO: ?
     DATA-ENTRY-RETURN: no
     DATE-FORMAT: dmy
     DEBUG-ALERT: no
     DISPLAY-TIMEZONE: ?
     DISPLAY-TYPE: GUI
     DOTNET-CLR-LOADED: yes
     ERROR-STACK-TRACE: no
     EXECUTION-LOG: no
     EXPORT: no
     FIRST-ASYNC-REQUEST: ?
     FIRST-BUFFER: ?
     FIRST-CHILD: 1045
     FIRST-DATA-SOURCE: ?
     FIRST-DATASET: ?
     FIRST-FORM: Progress.Windows.FormProxy
     FIRST-OBJECT: ?
     FIRST-PROCEDURE: ?
     FIRST-QUERY: ?
     FIRST-SERVER: ?
     FIRST-SERVER-SOCKET: ?
     FIRST-SOCKET: ?
     FRAME-SPACING: 21
     GET-PRINTERS: Microsoft XPS Document Writer,Fax
     GET-WAIT-STATE: 
     HANDLE: 20
     HEIGHT-CHARS: 38.1
     HEIGHT-PIXELS: 800
     ICFPARAMETER: 
     IMMEDIATE-DISPLAY: no
     INHERIT-BGCOLOR: yes
     INHERIT-COLOR-MODE: 1
     INHERIT-FGCOLOR: yes
     INSTANTIATING-PROCEDURE: ?
     LAST-ASYNC-REQUEST: ?
     LAST-CHILD: 1018
     LAST-FORM: Progress.Windows.FormProxy
     LAST-OBJECT: ?
     LAST-PROCEDURE: ?
     LAST-SERVER: ?
     LAST-SERVER-SOCKET: ?
     LAST-SOCKET: ?
     LOCAL-VERSION-INFO: Progress.Lang.OEVersionInfo_1112
     MULTITASKING-INTERVAL: 0
     NUMERIC-DECIMAL-POINT: .
     NUMERIC-FORMAT: AMERICAN
     NUMERIC-SEPARATOR: ,
     OLE-INVOKE-LOCALE: 0
     OLE-NAMES-LOCALE: 1033
     PARAMETER: 
     PIXELS-PER-COLUMN: 5
     PIXELS-PER-ROW: 21
     PRINTER-CONTROL-HANDLE: 0
     PRINTER-HDC: 0
     PRINTER-NAME: Microsoft XPS Document Writer
     PRINTER-PORT: XPSPort:
     PROXY-PASSWORD: ?
     PROXY-USERID: ?
     REMOTE: no
     SCHEMA-CHANGE: 
     SERVER-CONNECTION-BOUND: no
     SERVER-CONNECTION-BOUND-REQUEST: no
     SERVER-CONNECTION-CONTEXT: 
     SERVER-CONNECTION-ID: 
     SERVER-OPERATING-MODE: 
     STARTUP-PARAMETERS: -pf C:\Progress\OpenEdge\startup.pf,-cpinternal ISO8859-1,-cpstream ISO8859-1,-cpcoll Basic,-cpcase Basic,-d dmy,-numsep 44,-numdec 46,(end .pf),-p _desk.p
     SUPER-PROCEDURES: 
     SUPPRESS-WARNINGS: no
     SUPPRESS-WARNINGS-LIST: 
     SYSTEM-ALERT-BOXES: yes
     TEMP-DIRECTORY: C:\OpenEdge\WRK\
     THREE-D: yes
     TIME-SOURCE: LOCAL
     TIMEZONE: ?
     TOOLTIPS: yes
     TYPE: PSEUDO-WIDGET
     V6DISPLAY: no
     WIDTH-CHARS: 256
     WIDTH-PIXELS: 1280
     WINDOW-SYSTEM: MS-WINXP
     WORK-AREA-HEIGHT-PIXELS: 760
     WORK-AREA-WIDTH-PIXELS: 1280
     WORK-AREA-X: 0
     WORK-AREA-Y: 0
     YEAR-OFFSET: 1950


. TIA .

Posted by OctavioOlguin on 16-Sep-2015 19:54

and by WINMERGE program.

these are the  only different lines:

Date: 16/09/15   Time: 19:30:50

Machine name: OCTAVIO-PC

     GET-PRINTERS: Microsoft XPS Document Writer,Fax,Enviar a OneNote 2010

     PRINTER-NAME: Enviar a OneNote 2010
     PRINTER-PORT: nul:


Posted by Aidan Jeffery on 16-Sep-2015 20:52

Your client session is using ISO8859-1 for the internal code page, and collation BASIC.

In the BASIC collation table for ISO8859-1, é has exactly the same sort weight as e, and ñ has exactly the same sort weight as n.

If there is a unique index on the table that you are entering the data into, then the behavior you are seeing on the Mac is correct. Is it possible that the temp-table on your Windows 7 machine is defined with a non-unique index?

Posted by Libor Laubacher on 17-Sep-2015 04:10

> I think it is something local to the windows on mac?

It is related to -cpcoll which is set to basic. Set it to -cpcoll Spanish9 (with your prowin32 session).

Posted by OctavioOlguin on 17-Sep-2015 15:33

Done....

First of all, thanks for every effort on this.

Aidan, The app is the same, just different client connections to the same database, and 10 other clients differentiate the "value" and not worry about sort order for the letter/carácter.

Libor,  You nailed it... I put that parameter on program call (desktop link) and it worked ok... Just wonder, why on 15 years and all of them on Windows never had this problem before? I mean, on the Windows clients never needed to adjust this parameter, and now suddenly, this instance running on boot camp needed to adjust it?

Any way Thanks for other mistery solved.

Posted by Stefan Drissen on 17-Sep-2015 17:14

Compare the startup.pf files in your OpenEdge installation directories. They contain defaults, which are determined when installing OpenEdge. The defaults are guessed by the installer when installing based on your Windows locale settings.

Posted by OctavioOlguin on 18-Sep-2015 14:36

I checked each file on both machines, and got exactly the same on both:

-cpinternal ISO8859-1
-cpstream ISO8859-1
-cpcoll Basic
-cpcase Basic
-d dmy
-numsep 44
-numdec 46

I guess I shoud chage to Spanish9 all the cpcoll's in all 10 stations? 

(It sounds in my head, if it is working,don't mess with it..)

Posted by Libor Laubacher on 18-Sep-2015 14:54

If want want/need calño and calno not to be considered the same, then I am afraid so. Perhaps you never used this combination in a table with unique index.

Posted by Aidan Jeffery on 18-Sep-2015 15:49

Note that we don't have any information about the database here. If the client sessions (code page and collation) are configured to match the database, and if the temp-table matches a table in the database (especially the field that you are adding the data to, and the unique index on that field), then just changing -cpcoll will not be the complete solution - you will need to modify the database also.

I would recommend carefully considering what you really want the behaviour to be before making any changes.

Posted by OctavioOlguin on 21-Sep-2015 13:16

For 15 years I were safe and sound with this configuration,  database was installed (i have logs of everything) with the same parameter in the installer:  "ISO-8858-1 Basic,Basic" option as were the client networking packages installed...

And, of course that here in Mexico and as far I know, Argentina, Spain, Chile, Colombia, Ecuador, wich I know for sure: "Niño" is not the same as "Nino", meaning that there is diferentiation between both letters (character), (as in "Kid" and first name of a person, which they stand for) . Databse was born in V9, and evolved until finally dumped and loaded in v11.3 type II (it took three days).  The 11.3 database was created with the same install option (and on linux), and allways have coexisted "Niño" and "Nino" on DB (as value of a unique index),  just as this laptop in bootcamp came into picture is that this issue arose.

This day all seems ok as this laptop, with -cpcoll Spanish9 parameter, behave as usual.   Just I had the curiosity to know what happened as the .ini file of the app, as the startup.pf file are the same on every client.

Posted by Aidan Jeffery on 22-Sep-2015 08:33

Earliler in this thread you said the problem was with loading records into a temp-table -

"The problem as I missed to explain is that the unique key of a temp- table won't  allow "CALNO" value when "CALÑO" was already present on the temp-table I´m loading."

Where are you loading the records from? Are you loading them from an external file, or are you retrieving them from the database?

If you are retrieving the records from the database, is it possible that you have records containing both CALNO and CALÑO in the database? And if so, what is the purpose of the unique index in the temp-table? It is the "unique" setting that prevents CALNO and CALÑO from co-existing in the temp-table. So, does the index need to be unique?

This thread is closed