svn: /phpdoc/ja/trunk/reference/sqlite3/sqlite3/ construct.xml

mumumu                                   Tue, 02 Jun 2020 14:34:35 +0000

Revision: http://svn.php.net/viewvc?view=revision&revision=350005

Log:
Fix example

A column declared as "string" has numeric type affinity, which may cause
unexpected results.

This integrates user note 125069.

Changed paths:
    U   phpdoc/ja/trunk/reference/sqlite3/sqlite3/construct.xml

Modified: phpdoc/ja/trunk/reference/sqlite3/sqlite3/construct.xml
===================================================================
--- phpdoc/ja/trunk/reference/sqlite3/sqlite3/construct.xml	2020-06-02 14:32:12 UTC (rev 350004)
+++ phpdoc/ja/trunk/reference/sqlite3/sqlite3/construct.xml	2020-06-02 14:34:35 UTC (rev 350005)
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- $Revision$ -->
-<!-- EN-Revision: 347846 Maintainer: takagi Status: ready -->
+<!-- EN-Revision: 349998 Maintainer: takagi Status: ready -->
 <!-- Credits: mumumu -->

 <refentry xml:id="sqlite3.construct" xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink">
@@ -131,7 +131,7 @@
 <?php
 $db = new SQLite3('mysqlitedb.db');

-$db->exec('CREATE TABLE foo (bar STRING)');
+$db->exec('CREATE TABLE foo (bar TEXT)');
 $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')");

 $result = $db->query('SELECT bar FROM foo');