From: Philippe Verdy (verdy_p@wanadoo.fr)
Date: Sat Jul 07 2007 - 00:37:30 CDT
> 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