U++ forum: Welcome to the forum

SqlBinary and Postgres 9 [message #36298]

Fri, 18 May 2012 20:43

Zbych
Messages: 327
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