/usr/share/doc/cl-sql/html/default-string-length.html is in cl-sql 6.5.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | <?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>*DEFAULT-STRING-LENGTH*</title><meta name="generator" content="DocBook XSL Stylesheets V1.78.1" /><link rel="home" href="index.html" title="CLSQL Users' Guide" /><link rel="up" href="ref-ooddl.html" title="Object Oriented Data Definition Language (OODDL)" /><link rel="prev" href="standard-db-object.html" title="STANDARD-DB-OBJECT" /><link rel="next" href="create-view-from-class.html" title="CREATE-VIEW-FROM-CLASS" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">*DEFAULT-STRING-LENGTH*</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="standard-db-object.html">Prev</a> </td><th width="60%" align="center">Object Oriented Data Definition Language (OODDL)</th><td width="20%" align="right"> <a accesskey="n" href="create-view-from-class.html">Next</a></td></tr></table><hr /></div><div class="refentry"><a id="default-string-length"></a><div class="titlepage"></div><div class="refnamediv"><h2>Name</h2><p>*DEFAULT-STRING-LENGTH* — Default length of SQL strings.<strong>Variable</strong></p></div><div class="refsect1"><a id="idp57211136"></a><h2>Value Type</h2><p>
Fixnum
</p></div><div class="refsect1"><a id="idp56409648"></a><h2>Initial Value</h2><p><em class="parameter"><code>255</code></em></p></div><div class="refsect1"><a id="idp56411392"></a><h2>Description</h2><p>
If a slot of a class defined by
<code class="function">def-view-class</code> is of the type
<em class="parameter"><code>string</code></em> or
<em class="parameter"><code>varchar</code></em> and does not have a length
specified, then the value of this variable is used as SQL
length.
</p></div><div class="refsect1"><a id="idp56414992"></a><h2>Examples</h2><pre class="screen">
(let ((*default-string-length* 80))
(def-view-class s80 ()
((a :type string)
(b :type (string 80))
(c :type varchar))))
=> #<Standard-Db-Class S80 {480A431D}>
(create-view-from-class 's80)
=>
(table-exists-p [s80])
=> T
</pre><p>
The above code causes a SQL table to be created with the SQL command
</p><pre class="screen">CREATE TABLE (A VARCHAR(80), B CHAR(80), C VARCHAR(80))</pre></div><div class="refsect1"><a id="idp56633376"></a><h2>Affected By</h2><p>
Some SQL backends do not support
<em class="parameter"><code>varchar</code></em> lengths greater than 255.
</p></div><div class="refsect1"><a id="idp56635376"></a><h2>See Also</h2><p>None.</p></div><div class="refsect1"><a id="idp56636720"></a><h2>Notes</h2><p>This is a CLSQL extension to the CommonSQL API.</p></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="standard-db-object.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="ref-ooddl.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="create-view-from-class.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">STANDARD-DB-OBJECT </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> CREATE-VIEW-FROM-CLASS</td></tr></table></div></body></html>
|