I have a question on charset/sortorder for sybase server. This is configured while installing sybase. In 12.5.4 I understand we can load additional charsets for server and install additional languages,sort orders etc...

I understand we can also change the server charset after install but generally not recommended. Is it possible to have multiple charsets/sortorder for a single server and switch between that easily or is that available in Sybase 15 or is it possible to create a database within a server with different charsets..

My requirement is to easily load database data from a cp866 server to a cp850 server?is that possible directly in latest versions atleast?

I would like to know clear details about charset/sortorder area in sybase.