The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

We unloaded 40 or so databases to Sybase 11 using the "-an" flag and it preserved our legacy collation sequence of "850". However, when we use dbinit to create new databases we are unable to find a collation sequence that matches this legacy "850" collation. Neither "IBM850" nor "850LATIN1" match the sorting properties of the old "850" collation.

We found a collation sequence named "internal - code page 850, multilingual" that appears to have the same sorting properties as the legacy "850" collation.

Can anyone confirm that the two collations are equivalent for sorting purposes?

asked 11 Mar '10, 15:51

Jonesy's gravatar image

Jonesy
11112
accept rate: 0%


In short, yes they are.

The collation called "internal" appeared in 6.0.1 and was identical to "850". According to what I can dig up, Win 3.1 and Netware versions of SA defaulted to using a collation called "internal" in some places and, due to other changes, "internal" had to be added to the "official" collation list (though as a hidden entry) rather than being generated under the covers when needed.

In 10.0.0, "850" disappeared and "internal" remained. It was probably removed to eliminate duplication when that code underwent some other significant changes but I can't justify why it was "850" that was removed and not "internal".

-john.

permanent link

answered 11 Mar '10, 18:21

John%20Smirnios's gravatar image

John Smirnios
8.9k377112
accept rate: 39%

Thanks, John. This info is extremely helpful.

(15 Mar '10, 20:42) Jonesy 1
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×14
×5
×3
×1
×1

question asked: 11 Mar '10, 15:51

question was seen: 823 times

last updated: 23 Sep '11, 08:38