I have installed postgreSQL.
I use pgAdminIII as admin panel.
I am trying to watch tables content and see following:
How to avoid encoding problem?
-
2What is the encoding of your database?Nick Barnes– Nick Barnes2014-10-04 11:18:12 +00:00Commented Oct 4, 2014 at 11:18
-
1Just click on the database in the pgAdmin object browser. The encoding should be listed on the right.Nick Barnes– Nick Barnes2014-10-04 11:23:42 +00:00Commented Oct 4, 2014 at 11:23
-
There wrote: ** Encoding UTF8 **Коля я– Коля я2014-10-04 11:25:20 +00:00Commented Oct 4, 2014 at 11:25
-
@Nick Barnes dl2.joxi.net/drive/0005/3037/338909/141004/638c33dde3.jpgКоля я– Коля я2014-10-04 11:26:32 +00:00Commented Oct 4, 2014 at 11:26
-
@Nick Barnes do you have ideas?Коля я– Коля я2014-10-04 12:19:22 +00:00Commented Oct 4, 2014 at 12:19
Add a comment
|
1 Answer
For a UTF8 database, pgAdmin should always display strings correctly. The most likely explanation is that the data itself is incorrect.
This generally happens when a client application sends data in a format which doesn't match its client_encoding setting. If this is the case, setting client_encoding correctly would prevent this from happening (provided the client application's code page is supported by Postgres). This wouldn't fix the existing data, but it might be possible to repair it with the convert function.
5 Comments
Коля я
I executed it from windows cmd like this C:\Users\redwhite>psql -U marc -d marc_db -a -f D:\sql\postgres\init.sql
Коля я
In cmd I see following VALUES (1, 6, 'Р?РчС?Р?С<Р№ С'РчС?Р?РёР?Р°Р>', '19:00', '5', 55.67834420000001, 37.79668899999999, 35, 7, 'Р?РчС?Р?С<Р№', 0, 0, 0, 'linux', '9:00', 'Р?С?С?РєРёР?Р°', 'Р?РєС'РёР?РчР?', 0, 5, 9, 1, 1, NULL, 1, 1);
Nick Barnes
What happens if you run the script from pgAdmin?
Коля я
ddl(database creation) script doesn't work but insert script work properly and names are good encoded
Nick Barnes
You might just need to set psql's client encoding to match the file encoding. You can do this by running
set PGCLIENTENCODING=... in cmd. The list of allowed encodings is here.