Unix Technical Forum

Character set error

This is a discussion on Character set error within the pgsql Sql forums, part of the PostgreSQL category; --> Good Day. I´m working with postgres 7.4. on Win XP and when I do a query like select* from ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Sql

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 11:51 AM
Mauricio Fernandez A.
 
Posts: n/a
Default Character set error

Good Day.

I´m working with postgres 7.4. on Win XP and when I do a query like

select* from table

it returns me this error message:

Invalid character data was found. This is most likely caused by stored data
containing characters that are invalid for the character set the database
was created in. The most common example of this is storing 8bit data in a
SQL_ASCII database.

I know it´s a character set problem, I really have SQL_ASCII encoding but I
don´t know how to fix it

Any idea will be welcome

Thanks

Mauricio Fernández A.
Ingeniero de Sistemas
U. Autónoma de Manizales


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:18 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com