SQL Insert Statements data extractor does not wrap text values with quotes

When I run the SQL Insert Statement data extractor for data inside an MS SQL Server table, the text values are not wrapped with quotes.  Is there a way to configure this data extractor to wrap all text values with quotes?

5 comments

Hello Keith,

What IDEA version do you use ("Help - About")? Please try to check it with IDEA 13.1.2: http://www.jetbrains.com/idea/download/.

0

I discovered this when doing SQL Server extracts from IntelliJ IDEA 13.1.2.

0

It works fine on my environment.
Could you provide exact steps to reproduce and attach idea.log ("Help - Show Log in Finder").

0

Here are the steps I am using to reproduce this behavior:

  1. I created a data source for my SQL Server instance hosted on Microsoft Azure using the Microsoft SQL Server driver.  The driver filename downloaded by IDEA is sqljdbc4-4.0.2206.100.jar
  2. I opened the Table Editor for a table that contains columns defined as NVARCHAR
  3. I changed the data extractor to SQL Insert Statements
  4. I clicked on the Copy Data To button to extract the data


Attached to this reply is an attachment contain the DDL for the table in question and the results of running the extract.  Notice that the NVARCHAR column values are not wrapped with quotes.  Also attached is the IDEA log file.



Attachment(s):
TextValuesNotWrappedInQuotes.txt.zip
idea.log.zip
0

Thanks for the information!
I've created issue in YouTrack: http://youtrack.jetbrains.com/issue/IDEA-124479.
Please start following it to receive automatic notifications from YouTrack when the issue is updated.
See http://intellij-support.jetbrains.com/entries/23368682 if you are not familiar with YouTrack.

0

Please sign in to leave a comment.