Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL++ - Programming with the C++ API to MySQL
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
ODBC - ODBC with the MySQL Connector/ODBC driver
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
mysql openssl Question
mysql:it 's a db not a dbms how it 's possible?!
Does the binary log enabling affect the MySQL performances?
Strange behavior, Table Level Permission
FULLTEXT query format question
Preventing Duplicate Entries
Comparing and writing out BLOBS
Executing MySQL Commands From Within C Program
Can 't access mysql after kernel upgrade
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Downgrade Mysql from 4 to 3 23
MySQL Cluster Software
mysql test 4 1 fails with the gis test
ERROR 2002: Can 't connect to local MySQL server through socket
Getting Identity after INSERT
Update one field with more fields from another table
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
mysql have same function mthod as Oracle decode()
 
How to Insert linefeed chatacter in a string: Inserting Linefeed into Stri

How to Insert linefeed chatacter in a string: Inserting Linefeed into Stri

2006-08-16       - By Michael Neuber

 Back
Reply:     1     2     3  

I am looking for a solution to following problem:
I wanted to insert a string to the a maxDB (7.5.00.34)
containing the a CRLF (Carriage Return Line feed, here marked as \n) :

insert into testtable ( stringattribute) values('ABCDE \n\\www.abc.de')

Had similar probs as described in the thread
RE: How to Insert linefeed chatacter in a string - Derek M. A. Lee-Wo,
June 2 2006 2:18pm

Though, in my case ist really a VARCHAR attribute, and I managed to to
it with a CRLF character in many cases.

However, when the next chars are 2 slashes on the new line, the CLI
obviously thinks there's the end of the previous command, though I am
still writing a string ( closing ' has not yet come !)

Is there a way to make clear to the CLI that I am still writing a string
content and that the new line's // belong to that content?

Regards
M.Neuber


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=mysql@(protected)