Re: TeraScript-Talk: Case

2014-11-04 Thread BEVERLY VOTH
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

Re: TeraScript-Talk: Case

2014-11-04 Thread Dan Stein
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

RE: TeraScript-Talk: Case

2014-11-03 Thread Robert Shubert
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