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: 2005-12-25 09:34:42
Message-ID: 43AE67B2.9060208@adamnet.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tatsuo Ishii 2005-12-25 09:50:01 Re: [BUGS] BUG #2120: Crash when doing UTF8<->ISO_8859_8
Previous Message Tony 2005-12-24 19:43:45 BUG #2125: SELECT problem with strings containing \

Browse pgsql-patches by date

  From Date Subject
Next Message Tatsuo Ishii 2005-12-25 09:50:01 Re: [BUGS] BUG #2120: Crash when doing UTF8<->ISO_8859_8
Previous Message Qingqing Zhou 2005-12-25 02:50:52 Re: Improve XLOG_NO_TRAN related comments