On 03/04/2014 07:39 AM, Adrian Klaver wrote:
CCing list:
> <quote author='Adrian Klaver-4'>
> On 03/04/2014 03:03 AM, ajay wrote:
>> hello team ,
>>
>> i am trying to enter this insert command in postgres
>> insert into mmsuper.notification
>> values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
>> balance',5);
>> now when i am trying to paste this in postgres in Solaris , it is giving
>> me
>> error
>>
>> fm_db_Server1-# insert into mmsuper.notification
>> values('101','12','13','Segmentation Fault
>>
>> and comes out of postgres prompt....
>> also when i am trying to press up arrow key , then also it is giving me
>> above error.
>>
>> But in Linux this is working fine ..without any error
>
> Well this has encoding/locale issues written all over it.
>
> So what is the encoding/locale for your Linux machine vs the Solaris
> machine?
>
> The same for the Postgres instances on each or are you inserting into
> the same Postgres instance?
>
>>
>> Please help it is very very urgent..
>>
>>
>>
>> Thanks
>> Akshat
>>
> thanks for the reply ,..
>
> When i am trying to enter anything else other then some Arabic , Hindi
> .. that case it does not give this error.
>
> like if i enter..
> insert into table values('welcome',1);
> then it does not give any error and get successfully
I would try Toms suggestion about readline. If that does not work then
we are back to questions I asked above about the encodings you are
working with.
>
> Thank
--
Adrian Klaver
adrian.klaver@aklaver.com