[Aidan Whitehall]

'Khushboo' wrote on '31:

Issue confirmed as described. This is a known issue if the cell value is (NULL). It has been fixed in 8.5Beta3 we released last week. Can you please verify the fix in your environment?

Yes, 8.5 beta 3 does fix this.

Thanks for your help!

[Aidan Whitehall]

'peterlaursen' wrote on '31:

We cannot reproduce this.

[snip]

Are we missing something here?  Or maybe you are trying with an ENUM column?

I didn't realise I'd hit upon a particular set of circumstances where this seems to manifest itself.

Have just gone through the steps again and found that it happens when you:

• execute the SQL statement by pressing F8, or press F9 and select the table name in the drop-down, and then
• paste a value into a date field where the retreived value is NULL (this appears to be the important factor)

The format of the value I was pasting is 2010-01-01 00:00:00

Hope this helps.

[Aidan Whitehall]

'peterlaursen' wrote on '29:

We will check this but please tell what the old and new versions you are referring to are exactly. In particular the new one.

Sorry Peter, am using 8.4 Community. Am not sure if the previous version (which was the first one in which I noticed this) was 8.2 or 8.3 Community.

[Aidan Whitehall]

navyashree.r wrote on May 12 2009, 06:41 AM:

This can be achieved by disabling the option “Escaped By” in the Export table data/Result as CSV — Change option.

*slaps forehead*… of course!

Thank you 🙂

[Aidan Whitehall]

peterlaursen wrote on May 11 2009, 09:09 PM:

OK .. I realize you need a single “” written to the file for this. We will have to find a solution!

In the meantime you cannot 'search and replace' “\” with “” somehow?

Yes — I've been doing a manual Search & Replace once the files have been exported for the last few years :huh: And I'm starting to generate more .bat files containing paths, which was what prompted me to try to find a way of avoiding having to do the Search & Replace.

I appreciate the time you've taken to look at this, Peter… thank you for that, and any thoughts you might have in being able to find a way around this issue.

[Aidan Whitehall]

Hi Peter… thanks for all the useful information!

peterlaursen wrote on May 11 2009, 10:47 AM:

.. so in conclusion escaping is a server functionality and not a client functionality (but the client must of course respect how the server escapes – and that iw why we generate double \'s!). Every time the server reads a it will escape!

So question is why do you require single 's in the file? The way we handle the 'backsash' character in CSV-export is how the server would do with SELECT INTO OUTFILE, and when improting we use LOAD DATA syntax.

To answer your question, I use data stored in MySQL to generate Windows batch files. A SELECT uses CONCAT() and a field that hold a Windows directory to generate command line instructions for the batch file.

I then use the “Export to CSV” feature, but instead save the file with a .bat extension so the statements within the exported file can simply be run by double-clicking on them. Currently I have to go into each file generated and do a manual Search and Replace to change “\” to “” in order for the Windows paths in the .bat file to be valid.

peterlaursen wrote on May 11 2009, 10:47 AM:

But that said: in both CSV-import and CSV-export GUI's we will consider “” and “\” the same (= “\”). This we introduced some years ago since lots of users did not understand the need to enter “\” to generate a “” (in the datastore – not in the file!). As a result of this getting “” is not possisble if you use the GUI. But why do you want to? You would not be able to use the file with MySQL!

I'm fond of SQLyog, but if it's simply not possible I'll have to investigate another method of generating the batch file.

Thanks for your help!

[Author]

Posts