By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 916 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Client Encoding in postgresql

P: 27
hello all...

I am using postgres as my backend server and i need to insert some characters into tables... the server side encoding is UTF-8 and i am using the psqlODbc to connec to the database..
now for example if i try to insert some russian characters it inserts some '???????'
if i use the command set client encoding to UTF8, this sets the encoding to UTF-8 only for a particular session.

how do i make my application insert those russian values into my table..

Please help..

Thanks in advance for any help
Dec 4 '08 #1
Share this Question
Share on Google+
3 Replies


10K+
P: 13,264
1.)Make sure that your database encoding is set set UTF-8 (You can check that in pg_database).
2.) Make sure your client encoding is not set to SQL_ASCII.(That will disable all automatic conversion)
3.)Enable automatic client encoding using a persistent method. Section 21.2.3 of this page explains the different ways of doing it. The last ones are the more persistent.
Jan 7 '09 #2

P: 27
thanks for your reply.. i ll do what ever you've suggested
Jan 28 '09 #3

P: 2
Thank you !

It works fine

Vikki A
Jan 4 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.