From: | Louis Bertrand <louis(at)bertrandtech(dot)on(dot)ca> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | European character sets? |
Date: | 2000-09-18 13:21:07 |
Message-ID: | Pine.BSO.4.20.0009180907110.2616-100000@grendel.bts |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
Hello,
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 <louis(at)bertrandtech(dot)on(dot)ca>
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson Ricardo Schroeder | 2000-09-27 17:39:34 | test |
Previous Message | Chris | 2000-09-11 06:43:50 | saving files in a database |