Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Language collation

2 posts in General Discussion Last posting was on 2010-05-27 14:10:34.0Z
mmcgaughey Posted on 2010-05-27 08:09:04.0Z
Sender: 926.4bfe2826.1804289383@sybase.com
From: mmcgaughey
Newsgroups: ianywhere.public.general
Subject: Language collation
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bfe28a0.939.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 May 2010 01:09:04 -0700
X-Trace: forums-1-dub 1274947744 10.22.241.41 (27 May 2010 01:09:04 -0700)
X-Original-Trace: 27 May 2010 01:09:04 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8048
Article PK: 7072

The database I'm setting up is for antiquarian books, so as
well as current European languages I have titles in Latin
and Greek. The Greek letters are showing as question marks
in my database. Which collation should I use so that the
Greek characters are also recognised?


John Smirnios [Sybase] Posted on 2010-05-27 14:10:34.0Z
From: "John Smirnios [Sybase]" <smirnios_at_sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Language collation
References: <4bfe28a0.939.1681692777@sybase.com>
In-Reply-To: <4bfe28a0.939.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bfe7d5a$1@forums-1-dub>
Date: 27 May 2010 07:10:34 -0700
X-Trace: forums-1-dub 1274969434 10.22.241.152 (27 May 2010 07:10:34 -0700)
X-Original-Trace: 27 May 2010 07:10:34 -0700, vip152.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8049
Article PK: 7073

If you want to support a bunch of different alphabets, I would recommend
using UTF8 as your database character set and that narrows the collation
choice to either UCA or UTF8BIN. The UCA collation supports proper
linguistic sort rules or you can use UTF8BIN which is leaner but does a
more-or-less binary comparison of encodings rather than linguistic
comparisons. I would use UCA unless you are deploying to a mobile device
or if you need to squeeze the most out of every CPU cycle.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

On 5/27/2010 4:09 AM, mmcgaughey wrote:
> The database I'm setting up is for antiquarian books, so as
> well as current European languages I have titles in Latin
> and Greek. The Greek letters are showing as question marks
> in my database. Which collation should I use so that the
> Greek characters are also recognised?