characterset problem? combined statements
Posted by: marc.boncz
Date: January 12, 2006 01:29PM

Hi all,

Recently upgraded to 4.1 and now have a problem:
Both in Delphi and PHP appplications I used to have blocks of statements like this:

BEGIN;
STATEMENT 1;
STATEMENT 2;
COMMIT;

In PHP I tended to put "\r\n" behind this to keep echoes of the queryblock to screen readable, in Delphi I assume the queries are separated like this automatically when adding them to a string list before execution.

Now MySQL 4.1, unlike the previous version, throuws an error on this, for some reason it 'sees' the control characters (newline), leaves these in the statements and thus the statements are not executed.
In PHP this was easy to solve: no more 'newline' characters.
However, In Delphi I have no way to keep the newlines out of the blocks of statements.

How do I get these blocks of statements executed, without sending them one by one?

Guess it has to do something with the character set, probably have to set that to something else, but what?

Marc

Options: ReplyQuote


Subject
Views
Written By
Posted
characterset problem? combined statements
3748
January 12, 2006 01:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.