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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: [BUGS] BUG #2120: Crash when doing UTF8<->ISO_8859_8

  • From: Sagi Bashari <sagi(at)adamnet(dot)co(dot)il>
  • To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
  • Cc: pgman(at)candle(dot)pha(dot)pa(dot)us, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-patches(at)postgresql(dot)org
  • Subject: Re: [BUGS] BUG #2120: Crash when doing UTF8<->ISO_8859_8
  • Date: Sun, 25 Dec 2005 11:34:42 +0200
  • Message-id: <43AE67B2.9060208@adamnet.co.il> <text/plain>
On 23/12/2005 03:59, Tatsuo Ishii wrote:

BTW, the example code sequence (ISO-8859-8) Sagi posted seems to have
wrong one.

select 'ïïïïïïïï';
WARNING:  ignoring unconvertible ISO_8859_8 character 0x00d7
:
:

0x00d7(\327) is not listed in our ISO-8858-8/UTF-8 conversion map. Is
this OK or do we need to add the conversion for the code?
What do you think, Sega?
I'm not sure whats 0x00d7(\327). The example I sent is the word "shalom" (hello/peace) in hebrew, four letters, here's the ascii conversion: 
SELECT '××××';:
S=83
E=69
L=76
E=69
C=67
T=84
=32
'=39
×=249
×=236
×=229
×=237
'=39
;=59

Sagi
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group