Skip site navigation (1) Skip section navigation (2)

European character sets?

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 (view raw or flat)
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/


pgsql-php by date

Next:From: Jackson Ricardo SchroederDate: 2000-09-27 17:39:34
Subject: test
Previous:From: ChrisDate: 2000-09-11 06:43:50
Subject: saving files in a database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group