Alaska Software Inc. - Changing COLLATION in WAA (to create indexes)
Username: Password:
AuthorTopic: Changing COLLATION in WAA (to create indexes)
Alphonsos PangasChanging COLLATION in WAA (to create indexes)
on Tue, 14 Apr 2009 10:59:49 +0300
Does anybody know how to change collaton in WAA
It seems that the default collation in WAA is SYSTEM (COLLAT_SYSTEM or 1) 
and I want to define SET COLLATION to ASCII for my indexes (I am using 
DBFCDX dbe) (The default collation doesnt sort the GREEK characters 
correctly)

Thanks in advance,
Alf
Allen Lee Re: Changing COLLATION in WAA (to create indexes)
on Tue, 14 Apr 2009 07:10:37 -0700
Alphonsos Pangas wrote:
> Does anybody know how to change collaton in WAA
> It seems that the default collation in WAA is SYSTEM (COLLAT_SYSTEM or 1) 
> and I want to define SET COLLATION to ASCII for my indexes (I am using 
> DBFCDX dbe) (The default collation doesnt sort the GREEK characters 
> correctly)
> 
> Thanks in advance,
> Alf 
> 
> 
Have you tried:
set collation to ascii
Phil Ide
Re: Changing COLLATION in WAA (to create indexes)
on Tue, 14 Apr 2009 16:22:12 +0100
> Alphonsos Pangas wrote:
>> Does anybody know how to change collaton in WAA
>> It seems that the default collation in WAA is SYSTEM (COLLAT_SYSTEM or 1) 
>> and I want to define SET COLLATION to ASCII for my indexes (I am using 
>> DBFCDX dbe) (The default collation doesnt sort the GREEK characters 
>> correctly)
>> 
>> Thanks in advance,
>> Alf 
>> 
>> 
> Have you tried:
> set collation to ascii

SET COLLATION is a thread local setting, so whenever running a funtion that
may have been called from a web page, you will need to either issue issue
the SET COLLATION or check that it has already been done in that thread.

Regards,
Phil Ide

---------------------
www.xbhcl.com
www.pbih.eu
www.idep.nl
---------------------
Hell is kept warm with profane burners
Alphonsos PangasRe: Changing COLLATION in WAA (to create indexes)
on Wed, 15 Apr 2009 13:20:13 +0300
Thanks...There was no problem after all.  It is just a bit confusing 
reconciling set charset with set collation and WAA.

"Phil Ide" <phil@pbih.eu> wrote in message 
news:57scpznmz10p$.pwxpgucr3gpx$.dlg@40tude.net...
>> Alphonsos Pangas wrote:
>>> Does anybody know how to change collaton in WAA
>>> It seems that the default collation in WAA is SYSTEM (COLLAT_SYSTEM or 
>>> 1)
>>> and I want to define SET COLLATION to ASCII for my indexes (I am using
>>> DBFCDX dbe) (The default collation doesnt sort the GREEK characters
>>> correctly)
>>>
>>> Thanks in advance,
>>> Alf
>>>
>>>
>> Have you tried:
>> set collation to ascii
>
> SET COLLATION is a thread local setting, so whenever running a funtion 
> that
> may have been called from a web page, you will need to either issue issue
> the SET COLLATION or check that it has already been done in that thread.
>
> Regards,
> -- 
> Phil Ide
>
> ---------------------
> www.xbhcl.com
> www.pbih.eu
> www.idep.nl
> ---------------------
> Hell is kept warm with profane burners