Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Sorting on English and Spanish names
Thu, Aug 23 2007 5:47 PMPermanent Link

Mark Shapiro
What I would like to do is sort English and Spanish last names alphabetically in a grid
according to the English sort order. Is there any way to do that in SQL? Are there any
libraries available that replace accented Spanish letters with their English equivalents?
What's the best way to tackle this?

Mark Shapiro
Thu, Aug 23 2007 6:16 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mark,

<< What I would like to do is sort English and Spanish last names
alphabetically in a grid according to the English sort order. Is there any
way to do that in SQL? Are there any libraries available that replace
accented Spanish letters with their English equivalents? What's the best way
to tackle this? >>

If you use the English (United States) language for the table, it will
automatically treat all accented characters as the base character instead.
For example, the and o characters will collate to the same character, and
will raise a primary key exception if the accent is the only difference in
the key.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Aug 27 2007 11:05 AMPermanent Link

Mark Shapiro
Tim,

Thank you for the quick response. Just to be sure I understand, that means changing the
table Locale from ANSI Standard to English (United States)? Are there any side effects of
such a change that I should be aware of?

Mark Shapiro
Mon, Aug 27 2007 5:32 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mark,

<< Thank you for the quick response. Just to be sure I understand, that
means changing the table Locale from ANSI Standard to English (United
States)? Are there any side effects of such a change that I should be aware
of? >>

The sorting may be slightly different for non-alpha characters and accented
characters (already noted).   Other than that, there's no other side
effects.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image