From: | Peter Geoghegan <peter(at)2ndquadrant(dot)com> |
---|---|
To: | AI Rumman <rummandba(at)gmail(dot)com> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: I cannot insert bengali character in UTF8 |
Date: | 2012-07-20 10:40:08 |
Message-ID: | CAEYLb_W0jSRi7XDyu7XZSQBD9rhPtJT1K6+1hxW3TNYkNOAmZg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 20 July 2012 11:30, AI Rumman <rummandba(at)gmail(dot)com> wrote:
> I am using database with UTF8 and LC_CTYPE set as default value in
> Postgresql 9.1.
> But I cannot insert bengali character in a column.
>
> Query Failed:INSERT into tracker (user_id, module_name, item_id,
> item_summary) values ('1','Leads','353','বাংলা টেস্��...')::ADODB
> error::->ERROR: invalid byte sequence for encoding "UTF8": 0xe0a62e
>
> Item_summary is a text type column and we can insert japanese character in
> this field.
>
> Could anybody let me know what is the problem here?
Maybe they're not valid Bengali characters? Did you do an
encoding-naive truncation at some point?
My mail client cannot display the latter few characters before the
ellipsis, but can display the first few fine.
--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services
From | Date | Subject | |
---|---|---|---|
Next Message | Benjamin Adams | 2012-07-20 12:27:37 | Get DB Size by row |
Previous Message | Craig Ringer | 2012-07-20 10:32:44 | Re: data from the table is getting dropped when I am restarting my application after making changes in the objects created in my application in play |