Skip site navigation (1) Skip section navigation (2)

08.02.04.00 Updating column with Unicode

From: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: 08.02.04.00 Updating column with Unicode
Date: 2011-04-03 11:50:44
Message-ID: 4D985F14.7050108@joops.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello everybody,

I have detected some strange behavior updating columns with Unicodes 
strings.

Environment:
PostgreSQL 8.2.5
Database encoding: UTF8
ODBC: PostgreSQL Unicode Version 08.02.04.00

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=? 
WHERE record.id=?'
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.

Can anybody give me some hints ?

mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)

Postal
	Address
	_Josef(dot)Springer(at)joops(dot)com_
	Orlando-di-Lasso Str. 2
	D-85640 Putzbrunn
Phone
	Office
	+49 (0)89 600 6920
	
	
Phone 	Fax
	+49 (0)89 600 69220
	
	
Web
	Web
	http://www.joops.com
	
	

JOOPS
	(HRB München 86239)

*-- the software company --*

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2011-04-04 13:18:45
Subject: Re: 08.02.04.00 Updating column with Unicode
Previous:From: Adrian KlaverDate: 2011-04-01 16:55:33
Subject: Re: [gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]

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