Sybase Sort order and Charset

Sybase Sort order and Charset

Post by Rajes » Mon, 14 Jul 2003 10:07:14



Which sort order and char set is preferable for Sybase installations?
What is the default?
How to find the current sort order and charset?

Binary Sort Order
Dictionary order, case sensitive
Dictionary order, case insensitive, uppercase preference
Dictionary order, case insensitive, no preference
Dictionary order, case insensitive, accent-insensitive

-Rp?

 
 
 

Sybase Sort order and Charset

Post by Karl Ritte » Mon, 14 Jul 2003 17:39:58


Quote:> Which sort order and char set is preferable for Sybase installations?

The default charset of the platform.
iso_1   for Sun, Linux, Aix
roman8 for HP
iso_1/cp850 for windows

Quote:> How to find the current sort order and charset?

sp_helpsort


Quote:> Which sort order and char set is preferable for Sybase installations?
> What is the default?
> How to find the current sort order and charset?

> Binary Sort Order
> Dictionary order, case sensitive
> Dictionary order, case insensitive, uppercase preference
> Dictionary order, case insensitive, no preference
> Dictionary order, case insensitive, accent-insensitive

> -Rp?