I'm using PSQL 8.7 and trying to figure out how to use the COLLATE arguement
of CREATE TABLE. I need to create tables using a French ACS. According to
the documentation for CREATE TABLE, I can specify COLLATE:
CREATE TABLE t5 (c1 CHAR(20) COLLATE 'c:\pvsw\samples\upper.alt');

Where can I get a collate file for French?
There is a file called COLLATE.CFG which appears to contain multiple ACS's.
Is there some way to use this with SQL?
Is there a tool that I can use to extract the various languages from
COLLATE.CFG into '.alt' files?

Thanks,
- Greg

You have two options:
1) You can ignore the ACS and instead use an International Sort Rule
(ISR). The ISR is designed for proper handling of non-English
character sets, and can handle a variety of languages. ISR's for
French are already built into the problem.
2) You can build your own ACS. The ACS is simply a 265-byte file
consisting of a signature byte, an 8-byte ACS name, and the alternate
collating sequence you wish to use.

The ISR is much more flexible, and is already done for you. I would
recommend going that route. See your online manuals for more details
on using the ISR.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/2007 ***

Greg D wrote:

Hi Bill,

I did a search on the pervasive website for ISR and found Solution ID:
00016598 which states:

"SQL: The SQL interface currently does not support ISRs. If you have an
existing MicroKernel data file set up to use an ISR, you will receive
inconsistent results when reading the file through a SQL interface. "

I guess I need to get the ACS files for the relevant languages as I use both
the SQL and transactional interfaces extensively.

Thanks,
- Greg

"Bill Bach" <goldstar (AT) speakeasy (DOT) net> wrote

That would make it more challenging. Haven't ever needed ISR's myself,
so I've not played with them before personally.


Greg D wrote: