CHAPTER 8
piotrmichaljaniszewski opened this issue · 5 comments
Hello i have problem with Chapter 8: Table Design That Works for You
i cant create index , I see this message :
ERROR: invalid byte sequence for encoding "UTF8": 0x00
CONTEXT: COPY pls_fy2014_pupld14a, line 1
SQL state: 22021
Can you help me ? thanks a lot
Hi, what is your operating system?
Also, would you please run these two commands and report back the results?
SHOW client_encoding;
SHOW server_encoding;
hi, i have macos
OK, those settings are the same as on my Mac. I just downloaded the file, created the table and imported it. Would you please re-download a fresh copy of the file, do not touch it with any text editor, and try again?
now everything works, I checked chapter 9 and it's ok too.
thank you for your help.
Greetings from Poland
Excellent! Enjoy the book!