From: Bob G. <bo...@rc...> - 2007-05-23 13:49:55
|
This is probably a dumb question, but here I am an english speaker/writer trying to create a german language database. This error occurred after attempting to create the sql-ledger database with the Germany-DATEV-SKR03 chart of accounts. No multibyte encoding was selected. Error! INSERT INTO gifi (accno,description) VALUES ('0000100', 'Aufwand Gesch=EF=BF=BDftsbetrieb') ERROR: invalid byte sequence for encoding "UTF8": 0xe46674 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". -------- Next step... I went back to the datasete creation screen and selected Unicode UTF-8 from the drop down menu. Clicking continue, I get: Error! CREATE SEQUENCE id start 10000 ERROR: relation "id" already exists --------- Going back to the beginning (my usual mode of operation), with: template1=3D# DROP DATABASE "sql-ledger"; DROP DATABASE template1=3D#=20 I then have to go back two steps to the create database screen. But, alas, I get: Error! FATAL: database "sql-ledger" does not exist Of course it does not exist. I am trying to create it. Why the error.. |