Feature request: Collation settings on connection level

[Bart Pietercil]

Table Structure is like this

T1 Languages(fld_Lang)
T2 Modules(fld_mod_id, some other fields with non-language related  
info (numbers,ids,...))

T3 Modules_Translated 
(id,fk_modid,fk_language_id,title,description,......)


Now the german speaking person logs in and retrieves  a module AND  
the appropriate (in german language id) Modules_Translated.
Same for the french guy (retrieves the french records)

now I need the Modules Translated german result set order collation  
'german', and the Modules_Translated french result set collated french.


Even in a less complicated setting where user first and lastnames are  
stored, the french guy when retrieving this records expect them to be  
ordered 'the french way' and a german wants the 'german' way (don't  
get me started on 'the greek way' :-))


now for this last example I think your suggestion works
TIP:
     you can make virtual field (Table Method) and specify
     for it other location, then its index will be DIFFERENT.
     Payment for this -- overhead to maintain this index.

I don't really see how I can specify for a field a collation but will  
look into it


I understand your problem, but I am sure I worked with databases  
(don't remember which one) that permitted me to define indexes for a  
given collation and let me specify what index to use when doing a sort.

Bart




On 19-jun-07, at 11:16, Ruslan Zasukhin wrote:

> On 19/6/07 12:04 PM, "Thorsten Hohage"  
> <thohage at objectmanufactur.com> wrote:
>
>>
>> The last sentence is exactly the point I'm and I think Bart is
>> talking about. I have
>>
>> 1 VServer created with "my" collation settings and 10 users, but
>>
>> 3 from Spain
>> 3 from USA
>> 4 from Germany
>>
>> and the germans want a german sort order, the spain their common and
>> of course the USA boys their while all connected to the same server
>> and the same db.
>
> STOP !!!
>
> So they all 3 WATCH into the same Table Person ?
>
> And this table contains what?
>     MIXED three human languages?
>
> And German user later do SELECT of all records and want GERMAN order?
>     but what this German ORDER means for Spain or USA names?
>
> Or your German user SELECT only German records and then want sort  
> them?
>     i.e. You keep in the same table THREE sets of names,
>     but each user uses only OWN set of records ??
>     Then may be to have 3 tables?
>
>
> -- 
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina