| From: | Andrew Biagioni <andrew(dot)biagioni(at)e-greek(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Mis-interpreted extended character |
| Date: | 2003-12-13 15:18:18 |
| Message-ID: | 3FDB2DBA.8000505@e-greek.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Our database ( (PostgreSQL) 7.3.5 ) uses Unicode encoding:
egreek=# \l
List of databases
Name | Owner | Encoding
-------------+----------+----------
egreek | andrew | UNICODE
For some reason, If I try to use an extended character (ASCII code >
127) in a string, I get this peculiar result:
egreek=# SELECT LOWER ( 'Niño' );
egreek'#
(note: it fails to see the closing single-quote character; I hit
CTRL-C to quit the operation)
and:
egreek=# SELECT LOWER ( 'Niño ' );
ERROR: Unicode >= 0x10000 is not supported
(note: I added a space before the closing quote).
It looks to me like the 'ñ' character (spanish n with tilde - ASCII 164,
as far as I can tell) is messing with the parser somehow.
Furthermore -- this is data coming from a form in a web site used
globally, so I have little control over what is passed to me (me =
PostgreSQL DB). I can't (without lotsa hassles) "demand" that
higher-ASCII characters be encoded on the way in, and decoded on the way
out.
Any suggestions/info/hints?
Thanks,
Andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris | 2003-12-13 15:38:46 | Re: Mis-interpreted extended character |
| Previous Message | sreekant kodela | 2003-12-13 10:48:22 | How to synchronize two pg databases |