Re: [GENERAL] Unicode vs SQL_ASCII DBs

2004-02-02 Thread John Sidney-Woollett
Kris Jurka said: > If you need "english" sorting like "en_GB" then that is the best option, > but if you just need regular sorting the C locale might be better. It is > sometimes confusing how en_US (I assume GB is similar) sorts strings with > spaces and punctuation and so on. If I switch from "

Re: [GENERAL] Unicode vs SQL_ASCII DBs

2004-02-02 Thread Kris Jurka
On Mon, 2 Feb 2004, John Sidney-Woollett wrote: > Kris, thanks for you feedback. Can you give me any further info on the > questions below? > > Kris Jurka said: > >> 3) If I want accented characters to sort correctly, must I select > >> UNICODE > >> (or the appropriate ISO 8859 char set) over SQ

Re: [GENERAL] Unicode vs SQL_ASCII DBs

2004-02-02 Thread John Sidney-Woollett
Kris, thanks for you feedback. Can you give me any further info on the questions below? Kris Jurka said: >> 3) If I want accented characters to sort correctly, must I select >> UNICODE >> (or the appropriate ISO 8859 char set) over SQL_ASCII? > > You are confusing encoding with locale. Locales de

Re: [GENERAL] Unicode vs SQL_ASCII DBs

2004-01-31 Thread Kris Jurka
On Sat, 31 Jan 2004, John Sidney-Woollett wrote: > Hi > > I need to store accented characters in a postgres (7.4) database, and > access the data (mostly) using the postgres JDBC driver (from a web app). > > Does anyone know if: > > 2) Can SQL_ASCII be used for accented characters. Not with the

[GENERAL] Unicode vs SQL_ASCII DBs

2004-01-31 Thread John Sidney-Woollett
Hi I need to store accented characters in a postgres (7.4) database, and access the data (mostly) using the postgres JDBC driver (from a web app). Does anyone know if: 1) Is there a performance loss using (multibyte) UNICODE vs (single byte) SQL_ASCII/LATINxxx character encoding? (In terms of ex