Skip to main content
Released

Align SQLite, Spatialite, Geopackage Writer Table Name.Field Name constraints to specifications

Related products:FME Form
  • November 21, 2024
  • 2 replies
  • 12 views
geomancer
danilo_fme
bwn
s.jager
mhab
  • geomancer
    geomancer
  • danilo_fme
    danilo_fme
  • bwn
    bwn
  • s.jager
    s.jager
  • mhab
    mhab

bwn
Evangelist
  • Evangelist

Currently the SQLite, Spatialite and Geopackage Writers (all SQLite based) enforce constraints on table and column names that do not align with the format specifications.

For example, all formats allow Upper Case characters, spaces etc. within Table Names and Column Names, with only limitations that have to begin with an alphabetic character and certain SQLite Reserved words cannot be used without enclosing the field name in “”.

In order to maintain Schema alignment between Eg. a Data Source, like a Geodatabase, SQL Server etc. that may contain Upper Case characters, spaces etc.  then the corresponding SQlite based formats above should, by default, keep the Schema Attribute Names as-is, since similarly there is no requirement in their format specifications to enforce these rules, and most applications consuming the data will interoperate with these naming conventions fine.

Enforcement of lower case/removal of spaces should instead be optional as a user set Parameter.

2 replies

LizAtSafe
Safer
Forum|alt.badge.img+15
  • Safer
  • April 5, 2025
NewReleased

LizAtSafe
Safer
Forum|alt.badge.img+15
  • Safer
  • April 5, 2025
Forcing the attribute case in the writer for database formats is now available in FME 2025.0

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings