 |
SoftTree Technologies
Technical Support Forums
|
|
| 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: 7948
|
|
| |
|
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: 7948
|
|
| |
|
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: 7948
|
|
| |
|
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: 7948
|
|
| |
|
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: 7948
|
|
| |
|
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 |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
