473,591 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Client Encoding in postgresql

27 New Member
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
3 15898
r035198x
13,262 MVP
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
ravysters
27 New Member
thanks for your reply.. i ll do what ever you've suggested
Jan 28 '09 #3
vikkiatbipl
2 New Member
Thank you !

It works fine

Vikki A
Jan 4 '10 #4

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

Similar topics

2
3593
by: Rene Pijlman | last post by:
I can't seem to find any way to specify the character encoding with the DB API implementation of PyPgSQL. There is no mention of encoding and Unicode in the DB API v2.0 spec and the PyPgSQL README. When I have Unicode strings in Python and store it in a PostgreSQL Unicode database, will the data automatically be correctly encoded? Or do I need to specify the UTF-8 client encoding on the database connection somehow? I'm using the...
2
2045
by: Kathy Zhu | last post by:
Hi, sorry that this email is a little bit long, but it is actully not :-)) **** I have a database 'unidb' created with -E UNICODE. $ psql -l List of databases Name | Owner | Encoding -----------+---------+----------- unidb | kathy | UNICODE
1
1825
by: Pavel Stehule | last post by:
Hello I have only one questions. I am testing PostgreSQL for windows. All look well, but I can't set database encoding win1250. Its can be problem, because win1250 is often used encoding on win32 platform in our area. (PG7.5 don't support win1250 encoding on linux too). Administrator@NEMESIS /usr/local/pgsql/lib $ ../bin/createdb.exe -E win1250 aaa createdb.exe: database creation failed: ERROR: win1250 is not a valid
1
2638
by: Carlos Correia | last post by:
Hi, Here is the output a psql session. Please notice that the identation inconsistences in the records containg non ASCII chars is as outputed by psql. The db was created with LANIN9 and the console was ran (in the same machine) using UTF-8 (my system's default). I was surprised to notice that setting the client to unicode (which is
0
1283
by: Simon Niederberger | last post by:
Hi all I'm having some trouble with UTF8 / ISO-8859-1 encoding using a Webservice based on PEAR::SOAP_Server. The client essentially sends an XML file as data (i.e. XML-data wrapped in SOAP-XML envelope) to the server where it is processed. I've made sure the client sends data in ISO-8859-1, the XML data also has this encoding set in the PI. However, the server seems to receive the data as UTF8. Therefore, my german "umlaute" get all...
8
2673
by: Erwin Moller | last post by:
Hi group, I could use a bit of guidance on the following matter. I am starting a new project now and must make some decisions regarding encoding. Environment: PHP4.3, Postgres7.4.3 I must be able to receive forminformation and store that in a database and later produce it on screen on the client (just plain HTML).
0
1764
by: chitranjan | last post by:
Hi all I am working on PostgreSQL-8.2.4 ,and OS of my system is fedora-6. There are other 3 systems ,having same OS(fedora-6) and we can connect them through ssh.Actually, i am new in postgresql .I have already installed postgreSQL-8.2.4 on my system successfully and working fine. But I do'nt have any idea that ,how can i make server- clients .There are 4 systems , I want make one system as a server and other as a client .So explain me...
1
2253
by: chitranjan | last post by:
Is there separate packages for server and client in postgresql ? In MySQL , there are separate packages for client and server ..In PostgreSQL also there are two separate packages for client and server??.... Thanks in Advance Chitranjan Singh.
2
117901
by: wmstudio | last post by:
I have a PostgreSQL database encode in UTF-8. I try to do a mail merge from OOwriter. This seems to work except for non western characters. E.g. when I access the database from pgAdmin, a GUI client I can see all UTF-8 encoded characters. When I cut a text from the GUI and paste this text in OOwriter everything works well. The same text through a mail merge only shows question marks. An example: --------------- เมืองไทย TH Thailand ...
0
7871
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8236
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8366
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8227
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6642
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5735
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5400
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3851
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
1467
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.