my guess is that the JDBC ( or ODBC ) *driver* for FileMaker as a source is
what limits the case.
These docs might be helpful to those using FMS13:
https://fmhelp.filemaker.com/docs/13/en/fm13_odbc_jdbc_guide.pdf
https://fmhelp.filemaker.com/docs/13/en/fm13_sql_reference.pdf
You could try changing the storage in filmmaker to unicode and see if that
changes anything. I seem to remember doing that sometime ago and having it
work. But I may not be remembering correctly.
Dan Stein
theste...@me.com mailto:theste...@me.com
If evolution really works, how come mothers only
Wayne,
Case sensitivity in SQL comparisons is a function of the database server. As
far as I know, FileMaker does not have an option for case insensitive matching
when doing comparisons via ODBC/JDBC.
About the best thing I can offer from TeraScript’s perspective (and this would
be a