Feature request: Collation settings on connection level

[Ruslan Zasukhin]

On 19/6/07 11:16 AM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

>>> So when I am asking for connection based collation settings
>>> (different locales,different French secondary,....) I mean this kind
>>> of problem.
>> 
>> What exactly problem is?
>> 
>> What not works for you NOW ?
>> 
>> You want be able to make in French what?
>>     login?
>>     password?
>>     else?
>> 
>> I cannot catch this
> 
> How can I have AT THE SAME TIME but per connection have different
> collation settings?
 
> How can I have a 3 different sort orders for 3 different persons at
> the same time. 

> I don't see how I can specify this. It seems to me I
> can only specify a sort order for a table or a database, not for a
> connection ?

* So you have one VSERVER.

* you have ONE database under versver. Right?
    or three?

* you have 3 users around.

> How can I have a 3 different sort orders for 3 different persons at
> the same time. 
 
For the same database ???

You cannot, because SORT ORDER is reflected in the INDEX.
I.e. This is not connection issue, it is db storage issue



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]