Re^3: PgPP invalid byte seqnence for encoding UTF8

Replies are listed 'Best First'.
Re^4: PgPP invalid byte seqnence for encoding UTF8 by cormanaz (Deacon) on Mar 24, 2013 at 18:54 UTC
Here it is Table "public.user info" Column \| Type \| Modifiers \| Storage \| Description ------------------+------------------------------- +-----------+----------+------------- uid \| integer \| not null \| plain \| screen_name \| character varying \| not null \| extended \| user_name \| character varying \| not null \| extended \| location \| character varying \| \| extended \| user_language \| character varying \| \| extended \| favourites_count \| integer \| \| plain \| followers_count \| integer \| \| plain \| friends_count \| integer \| \| plain \| status_count \| integer \| \| plain \| listed_count \| integer \| \| plain \| created_at \| character varying \| \| exten ded \| time_zone \| character varying \| \| exten ded \| user_url \| character varying \| \| exten ded \| description \| text[] \| \| exten ded \| added_on \| timestamp without time zone[] \| \| exten ded \| Indexes: "pk_user" PRIMARY KEY, btree (uid) Rules: my_table_on_duplicate_ignore AS ON INSERT TO userinfo WHERE (EXISTS ( SELECT 1 FROM userinfo WHERE userinfo.uid = new.uid)) DO INSTEAD NOTHING Has OIDs: no [download] Maybe the problem is the brackets after the text type? Those were inserted when I created the column with pgadminIII.	[reply] [d/l]
Re^5: PgPP invalid byte seqnence for encoding UTF8 by McA (Priest) on Mar 24, 2013 at 18:58 UTC
I don't know psql well, but as far as I know, you introduced an array type for column description. I don't know how to feed the data for an array type via DBI. But that is something different than the initial question. McA	[reply]
Re^6: PgPP invalid byte seqnence for encoding UTF8 by cormanaz (Deacon) on Mar 24, 2013 at 19:10 UTC
Right. And not PERL any longer. Thanks for your help.	[reply]

                                Table "public.user
info"
      Column      |             Type              
| Modifiers | Storage  | Description 
------------------+-------------------------------
+-----------+----------+-------------
 uid              | integer                       
| not null  | plain    | 
 screen_name      | character varying             
| not null  | extended | 
 user_name        | character varying             
| not null  | extended | 
 location         | character varying             
|           | extended | 
 user_language    | character varying             
|           | extended | 
 favourites_count | integer                       |           | plain
    | 
 followers_count  | integer                       |           | plain
    | 
 friends_count    | integer                       |           | plain
    | 
 status_count     | integer                       |           | plain
    | 
 listed_count     | integer                       |           | plain
    | 
 created_at       | character varying             |           | exten
ded | 
 time_zone        | character varying             |           | exten
ded | 
 user_url         | character varying             |           | exten
ded | 
 description      | text[]                        |           | exten
ded | 
 added_on         | timestamp without time zone[] |           | exten
ded | 
Indexes:
    "pk_user" PRIMARY KEY, btree (uid)
Rules:
    my_table_on_duplicate_ignore AS
    ON INSERT TO userinfo
   WHERE (EXISTS ( SELECT 1
           FROM userinfo
          WHERE userinfo.uid = new.uid)) DO INSTEAD NOTHING
Has OIDs: no
[download]

[reply]
[d/l]

I don't know psql well, but as far as I know, you introduced an array type for column description. I don't know how to feed the data for an array type via DBI. But that is something different than the initial question.

McA

[reply]

Right. And not PERL any longer. Thanks for your help.

[reply]