#1  
Old 12th May 2005, 08:08 PM
Chris de Gelder
 
Posts: n/a
Default International sort order

Hi,

I am porting to Nexus (from FF 157) and it works great. Thanks a lot.

I distribute my database world wide and in ff I had to reindex all string
indexes when the codepage changed. Otherwise I would get key violations in
Japan (for example). Is that needed for Nx as well?

Regards,
Chris


  #2  
Old 12th May 2005, 08:53 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: International sort order

> I distribute my database world wide and in ff I had to reindex all string
> indexes when the codepage changed. Otherwise I would get key violations in
> Japan (for example). Is that needed for Nx as well?

The codepage is part of the index definition. You'll not have to restructure
to prevent key violations, but if you want to sort according to a specific
locale you'll have to restructure and define the locale you want to use.

Cheers,
Thorsten Engler




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort order of strings in ORDER BY clause Stefan Paege nexusdb.public.support.sql 6 6th March 2010 02:09 AM
Sort ORDER V3 differs from V2 Wina Jansen nexusdb.public.support.sql 2 24th July 2009 05:46 PM
Sort order Ivo Bauer nexusdb.public.support 21 17th January 2004 07:02 AM
Incorrect sort order Ole Willy Tuv nexusdb.public.support.sql 51 23rd October 2003 03:21 AM
sort order =?ISO-8859-1?Q?Kjell-=C5ke_Boberg?= nexusdb.public.support 3 1st October 2003 08:45 PM


All times are GMT +11. The time now is 01:33 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.