subject:"\[SQL\] problem inserting local characters ..."

Re: [SQL] problem inserting local characters ...

2005-02-22 Thread Joel Fradkin

y Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] problem inserting local characters ... Hi, Garry, Garry schrieb: > Trying to do this insert, I get an error on both the values > "TelefonGeschäft" and "Firmenstraße": > > FEHLER: ungÃ¼ltige Byte-Sequenz fÃ¼r Kodier

Re: [SQL] problem inserting local characters ...

2005-02-22 Thread Markus Schaber

Hi, Garry, Garry schrieb: > Trying to do this insert, I get an error on both the values > "TelefonGeschäft" and "Firmenstraße": > > FEHLER: ungÃ¼ltige Byte-Sequenz fÃ¼r Kodierung Â»UNICODEÂ«: 0xe165 This sounds as your database was created in unicode (utf-8). > (the 0xe165 differs between the

[SQL] problem inserting local characters ...

2005-02-22 Thread Garry

Hi, I'm running PostGreSql 7.4.6 on SuSE 9.1. Everything as such is working fine. In order to import some data from an old system, I create an SQL script that does something like: insert into prg_contacts values ('2005-02-22 13:45:36+01','NETHINKS Converter',NULL,NULL,'admin','s', NULL,NULL,NUL