Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » SqlBinary and Postgres 9
SqlBinary and Postgres 9 [message #36298] Fri, 18 May 2012 20:43 Go to next message
Zbych is currently offline  Zbych
Messages: 325
Registered: July 2009
Senior Member
Hi,

Since Postgres 9 default value of "standard_conforming_strings" has been changed to ON and it means that it is necessary to use E'...' escape syntax. Unfortunately SqlBinary doesn't do this.
Can you Mirek add an 'E' to binary case in SqlCompile?

		case SQLC_BINARY: {
			int l;
			ReadSqlValue(l, s);
			if(r) {
				if(l == 0)
					*r << "NULL";
				else
					switch(dialect) {
					case PGSQL: {
						*r << "E\'"; //<------ 
						const char *e = s + l;

[Updated on: Fri, 18 May 2012 21:32]

Report message to a moderator

Re: SqlBinary and Postgres 9 [message #36328 is a reply to message #36298] Sun, 20 May 2012 18:51 Go to previous message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Patch applied, thanks.
Previous Topic: Access to S_* Structure of TABLE crash Application.
Next Topic: Sql crash in 64 bit machine
Goto Forum:
  


Current Time: Thu Mar 28 23:30:24 CET 2024

Total time taken to generate the page: 0.00983 seconds