Hi folks,
does anybody have a good explanation why an insertion of a string into a
varchar field fails
if one tries to insert a string with a line break (i.e. CRLF) followed by one
or more dashes ?
(a 'Get Parameter for ...' popup window is comming up, asking for a parameter
for some variable coming next after the dashes,
in the example below, it would ask for a parameter for 'test')
Meaning something like this:
(Prerequisite: you have a table mytest with an attribute term varchar, in my
case varchar(7900). )
insert into test (term)
values('this is
a
---
test')
Sure, this is a really short drosophila example for a more complex
problem observed during data migration and subsequent trouble shooting.
But I think it should be possible to insert some dashed line into some text
which has CRLF-separated lines.
Note: (a) as far as I have seen, there can be blanks before the dashes in
order to create the same problem,
an added leading dot in front of the dashes, however, makes the insertion
possible.
(b) I am testing on DB server 7.5.00.38 on Windows and SQL studio 7.6.00.27
(123692)
Appreciating any feedback,
(also links to manual pages where I can read good examples
how parameter insertion really works (e.g. in SQL Studio)
and also how that can be avoided in case you are just not interested in
Parameter Insertron.)
Regards
Michael
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
