Export Issue with Quotes in Database - HeidiSQL Problem

Konstantinosstath's profile image Konstantinosstath posted 1 year ago in Import/Export Permalink

I have a problem when I export my database with a table because HeidiSQL uses single quotes (' ') instead of double quotes (" ") and when it exports then I get the problem you see in the photo. The issue stems from the fact that within our tables, we utilize single quotes (' '), which can cause confusion with the single quotes (' ') used in the database. is there any setting for this?

1 attachment(s):
  • Screenshot_1
ansgar's profile image ansgar posted 1 year ago Permalink

Well, MySQL accepts both single quotes and double quotes, while single quotes are preferred because I think they comply better to ANSI SQL.

What's exactly the problem? Is it just your highlighter which is confused or...?

Konstantinosstath's profile image Konstantinosstath posted 1 year ago Permalink

what I mean is that in my database I use single brackets ' ' and when the export also uses the same single brackets and it messes up the whole format and comes out useless, and I was wondering if there is a way to export them using " "

Konstantinosstath's profile image Konstantinosstath posted 1 year ago Permalink

quotes* (no brackets)

ansgar's profile image ansgar posted 1 year ago Permalink

No, HeidiSQL always uses single quotes for values.

Single quotes within a quoted value are escaped using a backslash:

Description

If your editor would understand the escaping your problem was solved.

Konstantinosstath's profile image Konstantinosstath posted 1 year ago Permalink

Ah ok now that you told me I got it I thought it was wrong and it wouldn't work because vsCode didn't understand it. I also did a test and it worked normally, so I assumed that my question - my problem was solved, thank you very much!!!

Please login to leave a reply, or register at first.