I am automating the production of LaTeX files but am noticing that depending on the selected database and scripting language there can be length limitations on the character strings being retrieved.
Q: Is there a cross platform text hungry (no 256 character limitations during exports - I know most text fields do have a customizable length limit) database system that is compatible with complex symbols and characters (i.e. new lines) that your experience has been shown to be highly compatible with LaTeX?
I realize this isn't a LaTeX question per se, but since the application is specific to LaTeX I am hoping for practical advice specific to TeX.
My current setup that has lead to problems is:
- Data in tables in MS Access database
- Query to concatenate column entries in specific rows into a LateX command
- An R script to connect to the database (RODBC package) and perform some string operations to build an export file with regular structure.
- This is the part that fails because a recent update to the package restricts column type exports to 256 characters.
- Because this is already not a cross platform approach, I am looking to improve the versatility of this flow.
- LaTeX builds on a manually produced main TeX file that includes these automatically produced files.