2007/7/16, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
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.)
The only thing that comes to mind is that two leading dashes start a line comment in SQL. Maybe you hit a bug in the parser that leads to this line being treated as comment. Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
