RE: SQL version of the Unicode database?

From: Philippe Verdy (verdy_p@wanadoo.fr)
Date: Sat Jul 07 2007 - 00:37:30 CDT

  • Next message: Philippe Verdy: "RE: SQL version of the Unicode database?"

    > De : unicode-bounce@unicode.org [mailto:unicode-bounce@unicode.org] De la
    > part de Stephane Bortzmeyer
    > Envoyé : vendredi 6 juillet 2007 15:04
    > À : Adam Twardoch
    > Cc : unicode@unicode.org
    > Objet : Re: SQL version of the Unicode database?
    >
    > On Fri, Jul 06, 2007 at 12:41:40PM +0200,
    > Adam Twardoch <list.adam@twardoch.com> wrote
    > a message of 23 lines which said:
    >
    > > some SQL databases support a LOAD command that allows you to open
    > > CSV files directly:
    > > http://dev.mysql.com/doc/refman/5.0/en/load-data.html
    >
    > That's not sufficient. For instance, if you want the categories' names
    > ("category values") in the database, you need to joint with other
    > files.

    It is sufficient to load a table ! All database engines have such a tool to
    load a table in a batch (or to use a delimited tabular text file directly),
    but they all need you provide a formal description of its format using some
    engine-specific syntax (or command line).

    Creating a relational database supposes that you create multiple tables, and
    each one will need to be loaded.

    Unicode does not provide a SQL script to create the database schema, because
    it would be engine-specific (mostly because of datatypes, but also because
    od the syntax for relations, referencial constraints, and unique keys); and
    the data-load SQL commands or tools are also engine-specific. All fields are
    documented however to allow you creating such database the way you want.



    This archive was generated by hypermail 2.1.5 : Sat Jul 07 2007 - 00:40:36 CDT