dbTalk Databases Forums  

MultyByte Question

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss MultyByte Question in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alexis Serafin
 
Posts: n/a

Default MultyByte Question - 07-18-2004 , 04:48 AM






-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi, I?m a spanish user from a short time and I?ve a problem each time I
tried to insert a record with a special character like (letter with
accent) which are supported under latin charset. The result is like:

PostgreSQL Error: 1 (ERROR: invalid byte sequence for encoding
"UNICODE": 0xfced6d )

The server (postgresql v.7.4.2-4 Debian Sarge) is installed under
UNICODE charset and the database is with this code (I?ve checked it with
pgsql -l)
The server machine runs under 8859-15 (european with euro symbol)

Anyone knows about this?

thanks
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFA+kds6qRqJtQ5jpkRAkv+AJ9Oip7gSt7q5Pr3nz5mHe pFnf5xBwCfaAGr
TLiQm2DnqelaYTbhHEuD0sw=
=JGOm
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


Reply With Quote
  #2  
Old   
Markus Bertheau
 
Posts: n/a

Default Re: MultyByte Question - 07-18-2004 , 05:49 AM






В Вск, 18.07.2004, в 11:48, Alexis Serafin пишет:
Quote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi, I?m a spanish user from a short time and I?ve a problem each time I
tried to insert a record with a special character like á ó (letter with
accent) which are supported under latin charset. The result is like:

PostgreSQL Error: 1 (ERROR: invalid byte sequence for encoding
"UNICODE": 0xfced6d )

The server (postgresql v.7.4.2-4 Debian Sarge) is installed under
UNICODE charset and the database is with this code (I?ve checked it with
pgsql -l)
The server machine runs under 8859-15 (european with euro symbol)
Set client_encoding appropriately:

http://www.postgresql.org/docs/curre...me-config.html

Possible values are:

http://www.postgresql.org/docs/curre...multibyte.html

--
Markus Bertheau <twanger (AT) bluetwanger (DOT) de>


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.