Feature request: Collation settings on connection level

[Bart Pietercil]

On 19-jun-07, at 01:06, Ruslan Zasukhin wrote:

> On 18/6/07 5:15 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:
>
> Hi Bart,
>
>> Hi List, Ruslan
>>
>>
>> I would like to introduce a feature request concerning collation
>> settings.
>>
>> As it stands now one can set Collation settings on database and table
>> levels.
>>
>> This , I think, is not enough for working in multilingual  
>> environments.
>>
>> Since in our solution multiple connections can be made to the same
>> server, same database, same table by users with different language
>> preferences we should be able to SET the collation settings at the
>> connection level.
>>
>> Is this feasible ?
>
> In fact on C++ level we have this,
>
> But then this is used by ADKs.
>     E.g. V4RB always talks in UTF8
>     V4MD in Latin-1
>     VNET in UTF16
I think I didn't make myself clear (or else in don't understand the  
answer).

When I say multilingual I mean human languages. In Belgium we have  
three official languages (from big to small) Dutch, French, German.
So it is perfectly possible that three person preferring these three  
languages, log in into the same VServer at the same time.
The db model has taken this into account (each person will be served  
its own language, the interface text will be looked up in the  
db,....) but 1 problem remains.
When the French speaking person asks for a sorted result, he will be  
expecting French secondary, the German speaking person will NOT want  
French secondary and so on.

So when I am asking for connection based collation settings  
(different locales,different French secondary,....) I mean this kind  
of problem.

Is there a way out ?


THX

Bart