I am developing a little database (PHP3+PostgreSQL) that needs to handle
non-english characters in the names (people being somewhat touchy when you
misspell their names).
I know very little about international (ISO?) character sets and I need
some RTFM references or hints to get started in the right direction.
Is it sufficient to set everything in the correct character set?
Do I need to do anything special for sorting (I hope the collating order
is handled correctly).
I'm also worried about searches: for example, if an english user selects
LIKE "Du%", I don't think he'll find "Durer" with u-umlaut. It seems to
me I'd have to handle this by substituting a regexp for each letter likely
to have special forms?
Confused and thankful in advance
Louis Bertrand http://www.bertrandtech.on.ca/
Bertrand Technical Services, Bowmanville, ON, Canada
Tel: +1.905.623.1500 Fax: +1.905.623.3852
OpenBSD: Secure by default. http://www.openbsd.org/
pgsql-php by date
|Next:||From: Jackson Ricardo Schroeder||Date: 2000-09-27 17:39:34|
|Previous:||From: Chris||Date: 2000-09-11 06:43:50|
|Subject: saving files in a database|