>For background info this is a follow up to thread # 465878. I have changed with Stonefield Tool Box all tags from 'general' back to be 'machine' , every tag has been updated but the application still sets collate to 'GENERAL'.
>
>I have identified the source of this problem and I don't see anything wrong in the coding ... duh
>
>1.- all references to collate in the registry are 'MACHINE'
>
>2.- when the application executes csessionenvironment.saveoldsettings the collate sequence is 'MACHINE' (as reported by a display status) but in csessionenvironement.set it changes to 'GENERAL'
>
>Note: When it enters .set, collate sequence is 'MACHINE' , when it finishes collate sequence is changed to 'GENERAL'.
>
>This is the code executed: at this point this.ccollate = 'MACHINE'
>
> IF EMPTY(this.ccollate)
> SET COLLATE TO "MACHINE"
> ELSE
> luTemp = this.ccollate
> SET COLLATE TO luTemp
> ENDIF
>
>Can someone shed some light on this and tell me where and why collate sequence is 'GENERAL' after executing csessionenvironment.set
>
>TIA
>
>Pierre Richard

Looking at all your tables, and the database container itself (as a table), what are their code pages, and what does IDXCOLLATE() return?