Postgres Pro
Downloads
Home   >   mailing lists

Has anyone come up with a work-around for the capitalization of non C-locale letters? - Mailing list pgsql-general

From Dann Corbit
Subject Has anyone come up with a work-around for the capitalization of non C-locale letters?
Date
Msg-id D90A5A6C612A39408103E6ECDD77B8299CAA1F@voyager.corporate.connx.com
Whole thread Raw
List pgsql-general
Tree view 
select productname, upper(productname) from products
gives this:

Gustaf's Knäckebröd                         GUSTAF'S KNäCKEBRöD
Tunnbröd                                    TUNNBRöD
Gumbär Gummibärchen                         GUMBäR GUMMIBäRCHEN
Tourtière                                   TOURTIèRE
Pâté chinois                                PâTé CHINOIS
Sirop d'érable                              SIROP D'éRABLE
Röd Kaviar                                  RöD KAVIAR
Rhönbräu Klosterbier                        RHöNBRäU KLOSTERBIER
Lakkalikööri                                LAKKALIKööRI
Original Frankfurter grüne Soße             ORIGINAL FRANKFURTER GRüNE SOßE

Which is failing the regression.

pgsql-general by date:

Previous
From: "Glen Parker"
Date:
Subject: Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly
Next
From: jseymour@LinxNet.com (Jim Seymour)
Date:
Subject: Re: Looking for help building 'rhdb-explain' Visual Explain tool