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

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-bugs by date

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

pgsql-patches by date

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

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