[GRASS5] 5.1: map/table name restrictions due to SQL

Radim Blazek blazek at itc.it
Tue Feb 18 03:15:39 EST 2003


On Monday 17 February 2003 11:25 pm, John A. Preston wrote:
> > > Question is if we want to restrict the map names completely for
> > > GRASS to the SQL rules or find a better workaround...
>
> I have gotton around this problem in programming URL's by
> translating the forbidden characters to a sequence of
> allowed characters, and translating the sequence back where necessary.
> Thus the user would be allowed to user wdbtemp4.area but if that had to
> be used as a table name it might be wdbtemp4#-#areas.
>
> What would be necessary is a pair of routines that encode/decode
> the table names taking care of any forbidden characters.

Yes, that could be possible solution, but then you get different name 
for table and vector. Problem is that to access data outside GRASS
(OOffice, pgaccess,...), user must have encode/decode routines in his head,
which doesn't seem to be user friendly enough.

Radim




More information about the grass-dev mailing list