Re: [GENERAL] invalid byte sequence for encoding UTF8: 0xab

2009-06-08 Thread Albe Laurenz
Mark D. Grand wrote: I am having a vexing problem with a script I am writing to populate reference tables in a new database. I am running postgreSQL 8.3 with psql 8.3.7. Psql reads this SQL statement: INSERT INTO META_AUTH.DOMAIN_META_ASSERTION (TITLE, DESCRIPTION,

Re: [GENERAL] invalid byte sequence for encoding UTF8: 0xab

2009-06-08 Thread Grand, Mark D.
] invalid byte sequence for encoding UTF8: 0xab Mark D. Grand wrote: I am having a vexing problem with a script I am writing to populate reference tables in a new database. I am running postgreSQL 8.3 with psql 8.3.7. Psql reads this SQL statement: INSERT

Re: [GENERAL] invalid byte sequence for encoding UTF8: 0xab

2009-06-08 Thread Dimitri Fontaine
Grand, Mark D. mgr...@emory.edu writes: It turns out that my problem was that the editor I was using (emacs) does not properly support utf8 encoding. Emacs does support utf8 properly. http://www.emacswiki.org/emacs/ChangingEncodings It could be I'm biased because I use emacs from CVS, which

[GENERAL] invalid byte sequence for encoding UTF8: 0xab

2009-06-05 Thread Grand, Mark D.
I am having a vexing problem with a script I am writing to populate reference tables in a new database. I am running postgreSQL 8.3 with psql 8.3.7. Psql reads this SQL statement: INSERT INTO META_AUTH.DOMAIN_META_ASSERTION (TITLE, DESCRIPTION, META_ASSERTION) VALUES ('Super-User

Re: [GENERAL] invalid byte sequence for encoding UTF8: 0xab

2009-06-05 Thread Tom Lane
Grand, Mark D. mgr...@emory.edu writes: ... I get this message: ERROR: invalid byte sequence for encoding UTF8: 0xab HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by client_encoding. It is complaining about

Re: [GENERAL] invalid byte sequence for encoding UTF8: 0xab

2009-06-05 Thread Vick Khera
On Fri, Jun 5, 2009 at 9:57 AM, Tom Lanet...@sss.pgh.pa.us wrote: The ASCII code for '' is 0x3c, not 0xab.  I am not sure what you are actually typing; although it's suggestive that the LATIN1 code 0xab corresponds to a symbol that looks approximately like ''.  The most likely bet is that you