U++ framework: U++ SQL » SqlBinary and Postgres 9

Home » U++ Library support » U++ SQL » SqlBinary and Postgres 9

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SqlBinary and Postgres 9 [message #36298]

Fri, 18 May 2012 20:43

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

[Message index]

		SqlBinary and Postgres 9 By: Zbych on Fri, 18 May 2012 20:43
		Re: SqlBinary and Postgres 9 By: mirek on Sun, 20 May 2012 18:51

Previous Topic:	Access to S_* Structure of TABLE crash Application.
Next Topic:	Sql crash in 64 bit machine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 28 09:50:44 GMT+2 2026

Total time taken to generate the page: 0.00744 seconds