problem inserting local characters ...
От | Garry |
---|---|
Тема | problem inserting local characters ... |
Дата | |
Msg-id | 421B2D3E.5040205@gmx.de обсуждение исходный текст |
Ответы |
Re: problem inserting local characters ...
|
Список | pgsql-sql |
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,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL, NULL,'Anrede','Titel','Vorname', NULL,'Firmenname','TelefonGeschäft','Faxnr', 'TelefonMobil','email@email.de',NULL,NULL, 'SMS-Pager','2.email@email.de','Firmenland','FirmenOrt', 'FirmenPLZ',NULL,'Firmenbundesland','Firmenstraße', NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL, [..] 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 (the 0xe165 differs between the two; the fields in question are regular type "text" fields) Looks like I'm having some trouble with unicode encoding ... The characters I have are regular 8bit ASCII chars ... How can I fix this? Help appreciated, -gg
В списке pgsql-sql по дате отправления: