| Author |
Message |
banita
Joined: 26 Feb 2011
Posts: 6
Country: Argentina |
|
 postgresql and encoding problem |
 |
I have a lot of problems with encoding. anyone know solution for this?
this screen is from windows notepad
with pgadmin when I try type:
... where name = 'ę' <------ when I try type 'ę' (Alt + e) char I got some chinesse character instead of my 'ę'.
with sql server 2008 r2 and sql management studio all seems to work fine
sory for my poor english
|
|
| Sat Feb 26, 2011 8:15 am |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
What's is the datatype of that column?
|
|
| Sat Feb 26, 2011 2:14 pm |
|
|
banita
Joined: 26 Feb 2011
Posts: 6
Country: Argentina |
|
| |
|
 |
|
CREATE TABLE miejscowosci
(
id_miejscowosci serial NOT NULL,
nazwa character varying(35) NOT NULL,
kod_pocztowy character(6) NOT NULL,
CONSTRAINT miejscowosci_pkey PRIMARY KEY (id_miejscowosci)
) |
|
|
| Sat Feb 26, 2011 5:27 pm |
|
|
banita
Joined: 26 Feb 2011
Posts: 6
Country: Argentina |
|
| |
|
can anyone help?
|
|
| Wed Mar 02, 2011 4:50 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
What's the database-level collation of your PostgreSQL database? Which PostgreSQL server version are you running?
|
|
| Wed Mar 02, 2011 5:37 pm |
|
|
banita
Joined: 26 Feb 2011
Posts: 6
Country: Argentina |
|
| |
|
I use postgresql 9 but with 8 problem still exist. all database and tables are in utf-8
sory for my poor english
|
|
| Tue Mar 08, 2011 4:00 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
But what about database-level collation of your PostgreSQL database? Can you answer that question?
|
|
| Wed Mar 09, 2011 9:44 am |
|
|
banita
Joined: 26 Feb 2011
Posts: 6
Country: Argentina |
|
| |
|
how can i check this?
|
|
| Sun Mar 13, 2011 7:32 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
in pgAdmin tool right click your database and choose Properties in the right-click menu. What do you see in Encoding property?
|
|
| Mon Mar 21, 2011 4:49 pm |
|
|
banita
Joined: 26 Feb 2011
Posts: 6
Country: Argentina |
|
| |
|
UTF-8
|
|
| Wed Mar 23, 2011 3:58 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
Thank you. That makes sense. SQL Assistant doesn't currently support display of Unicode values with double-byte character sets. It can display single-byte character sets only. If you are storing single byte character set text values in your table, please consider changing column collation to ASCII or compatible.
|
|
| Wed Mar 23, 2011 3:50 pm |
|
|
|
