Index: doc/src/sgml/charset.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/charset.sgml,v
retrieving revision 2.47
diff -c -c -r2.47 charset.sgml
*** doc/src/sgml/charset.sgml 27 Dec 2004 22:30:10 -0000 2.47
--- doc/src/sgml/charset.sgml 4 Jan 2005 00:02:40 -0000
***************
*** 189,198 ****
! Benefits>
! Locale support influences in particular the following features:
--- 189,198 ----
! Behavior>
! Locale support influences the following features:
***************
*** 204,209 ****
--- 204,216 ----
+ The ability to use indexes with LIKE> clauses
+ LIKE>and locales>
+
+
+
+
+
The to_char> family of functions
***************
*** 211,219 ****
! The only severe drawback of using the locale support in
! PostgreSQL> is its speed. So use locales only if
! you actually need them.
--- 218,228 ----
! The drawback of using locales other than C> or
! POSIX> in PostgreSQL> is its performance
! impact. It slows character handling and prevents ordinary indexes
! from being used by LIKE>. For this reason use locales
! only if you actually need them.
Index: doc/src/sgml/runtime.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v
retrieving revision 1.299
diff -c -c -r1.299 runtime.sgml
*** doc/src/sgml/runtime.sgml 26 Dec 2004 23:06:56 -0000 1.299
--- doc/src/sgml/runtime.sgml 4 Jan 2005 00:02:56 -0000
***************
*** 144,152 ****
that can be found in . The sort order used
within a particular database cluster is set by
initdb and cannot be changed later, short of
! dumping all data, rerunning initdb, and
! reloading the data. So it's important to make this choice correctly
! the first time.
--- 144,153 ----
that can be found in . The sort order used
within a particular database cluster is set by
initdb and cannot be changed later, short of
! dumping all data, rerunning initdb, and reloading
! the data. There is also a performance impact for using locales
! other than C> or POSIX>. Therefore, it is
! important to make this choice correctly the first time.
Index: doc/src/sgml/ref/initdb.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ref/initdb.sgml,v
retrieving revision 1.32
diff -c -c -r1.32 initdb.sgml
*** doc/src/sgml/ref/initdb.sgml 1 Aug 2004 06:19:18 -0000 1.32
--- doc/src/sgml/ref/initdb.sgml 4 Jan 2005 00:02:57 -0000
***************
*** 54,74 ****
! initdb initializes the database cluster's
! default locale and character set encoding. Some locale categories
! are fixed for the lifetime of the cluster, so it is important to
! make the right choice when running initdb.
! Other locale categories can be changed later when the server is
! started. initdb will write those locale
! settings into the postgresql.conf
! configuration file so they are the default, but they can be changed
! by editing that file. To set the locale that
! initdb uses, see the description of the
! option. The character set encoding can
be set separately for each database as it is created.
initdb determines the encoding for the
template1 database, which will serve as the
! default for all other databases. To alter the default encoding use
the option.
--- 54,75 ----
! initdb initializes the database cluster's default
! locale and character set encoding. Some locale categories are fixed
! for the lifetime of the cluster. There is also a performance impact
! in using locales other than C> or POSIX>.
! Therefore it is important to make the right choice when running
! initdb. Other locale categories can be changed
! later when the server is started. initdb will
! write those locale settings into the
! postgresql.conf configuration file so they are
! the default, but they can be changed by editing that file. To set the
! locale that initdb uses, see the description of
! the option. The character set encoding can
be set separately for each database as it is created.
initdb determines the encoding for the
template1 database, which will serve as the
! default for all other databases. To alter the default encoding use
the option.