Skip site navigation (1) Skip section navigation (2) Updating column with Unicode does not work

From: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Updating column with Unicode does not work
Date: 2011-04-14 08:36:49
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Hello everybody,

I have detected some strange behavior updating columns with Unicodes 

PostgreSQL 8.2.5
Database encoding: UTF8
ODBC: PostgreSQL Unicode Version

I am updating via ODBC a column (character varying nnn) of a record to 
an unicoded string.

Updating by using the command as one parameterblock
'UPDATE adresse SET company = ''Seifert und Partner KG EUR ??'' WHERE id 
= 1'
works right. (the whole parameterblock is encoded to UTF8)

Updating the record by using the command 'UPDATE adresse SET company=? 
and providing the arguments for ? UTF8-encoded in an extra buffer 
destroys the columns content.

If i update the column with an UTF8 encoded character in the default 
range (the EURO Sign EUR), it works.

It seems that:
*SQLExecute handles UTF8 encoded character in the right way
SQLBindParameter handles UTF8 encoded character** in the wrong way (bad 
Can anybody give me some hints ?

mit freundlichen Grüßen / best regards,
Josef Springer

	Orlando-di-Lasso Str. 2
	D-85640 Putzbrunn
	+49 (0)89 600 6920
Phone 	Fax
	+49 (0)89 600 69220

	(HRB München 86239)

*-- the software company --*

pgsql-odbc by date

Next:From: RaifordDate: 2011-04-14 12:17:38
Subject: Re: BYTEA Fields and Memory Consumption
Previous:From: Hiroshi InoueDate: 2011-04-14 03:41:45
Subject: Re: BYTEA Fields and Memory Consumption

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group