Hi Uli, websql is removing \r\n from the sql command. It is a known bug (webpts error 1125984). It will be fixed in one of the next releases.
Maybe for test purposes you could use SQL Studio. It does not remove \r\n. Regards Wolfgang -----Original Message----- From: Ulrich St�rk [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 19. Februar 2004 21:00 To: [EMAIL PROTECTED] Subject: Newlines Hi List, We have got a little problem with insert statements including newlines. We run a PHP application which inserts freetext from a HTML textarea field into an ASCII varchar field in our database. The PHP application puts the content of that textarea field in a query string and executes the query. The query looks like this: INSERT INTO table VALUES('Text a newline an empty line above this line') Checking that string returns that php stores it like this: INSERT INTO table VALUES('Text\r\na newline\r\n\r\nan empty line above this line') Up to this point everything looks as it should. We then use the linux SAP DB ODBC driver and iODBC to insert it into our database and at this point something mysterious happens: each \r and \n is replaced with a blank so that querying the database returns 'Text a newline an empty line above this line'. We thought that it might have something to do with the ODBC driver and/or iODBC and entered the same insert statement including the newlines into the websql interface - with the same result. We then tried different database servers: SAP DB 7.4 running on a Linux box, SAP DB 7.4 on a Solaris machine and MAX DB 7.5 on a Windows host. Same result at least when using the websql interface. Last thing we did was using the SAP DB 7.5 Windows ODBC driver and PHP on a Windows machine to insert that string into the database on the Windows host and it worked - the newlines where not replaced. We tried the SAP DB 7.4 driver to insert the same string into the SAP DB 7.4 database running on the Linux box and it worked too. We are a little stuck now and need your assistance. Any pointers on what we could try? Thanks in advance Uli St�rk -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
