Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

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".


permanent link

answered 11 Mar '10, 18:21

John%20Smirnios's gravatar image

John Smirnios
accept rate: 37%

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 11 Mar '10, 15:51

question was seen: 2,624 times

last updated: 23 Sep '11, 08:38