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

08.02.04.00 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: 08.02.04.00 Updating column with Unicode does not work
Date: 2011-04-14 08:36:49
Message-ID: 4DA6B221.3090202@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.

It seems that:
*SQLExecute handles UTF8 encoded character in the right way
SQLBindParameter handles UTF8 encoded character** in the wrong way (bad 
encoding)
*
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 --*

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-2014 The PostgreSQL Global Development Group