# export probs

**URL:** <https://forum.servoy.com/t/export-probs/2390>\
**Category:** Classic Servoy\
**Created:** [August 3, 2004, 8:18am UTC](https://forum.servoy.com/t/export-probs/2390 "2004-08-03T08:18:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Odysseus](https://avatars.discourse-cdn.com/v4/letter/o/cdc98d/32.png) [@Odysseus](https://forum.servoy.com/u/Odysseus)\
**Post date:** [August 3, 2004, 8:18am UTC](https://forum.servoy.com/t/export-probs/2390/1 "2004-08-03T08:18:37Z")

</div>

Hi guys,

problem: I’ve written a conversion tool for my servoy data to sqlite. Works perfectly (well…)  
I can export an sql file that contains all instructions to generate an sqlite file. There is one problem with the text qualifiers.  
I started using ’ as text qualifier but than hit the problem that in some languages ’ is used within text, so I switched to " as a text qualifier, enforcing quotes to be single quote. That worked OK until I wanted to export some html formatted code. This html uses “” in some place size=“3” or font=“tahoma”. This again messes things up. Since for html there is no need to use double quotes, single quotes render as well, here’s my question  
Is it possible to create a setting where you indicate that in html constants are in single quotes or do you see another solution ?

TIA

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [August 3, 2004, 9:09am UTC](https://forum.servoy.com/t/export-probs/2390/2 "2004-08-03T09:09:01Z")

</div>

the best is to escape the single quotes you find in text.  
By using two single quotes you escape it for SQL

---

<div class="post-metadata">

**Author:** ![Odysseus](https://avatars.discourse-cdn.com/v4/letter/o/cdc98d/32.png) [@Odysseus](https://forum.servoy.com/u/Odysseus)\
**Post date:** [August 3, 2004, 11:52am UTC](https://forum.servoy.com/t/export-probs/2390/3 "2004-08-03T11:52:34Z")

</div>

the single quotes are not the problem (anymore).

The problem lies in exporting an html area where constant values are double quoted. What I was looking for is a means of having the html area using single quotes in stead of the double quotes that are used by default.  
Those double quotes in my opinion should be single quotes by default or as some parameter in preferences

TIA

---

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [August 4, 2004, 10:05am UTC](https://forum.servoy.com/t/export-probs/2390/4 "2004-08-04T10:05:29Z")

</div>

Double qoutes are in the HTML spec, so they cannot be changed, using single qoutes en escaping single qoutes if found in the text is the most easy option.