Quoting Elver Loho (suppressed): > What I need documentation on is how to tell Interchange to send 'set > names utf8' (or the other string) to MySQL before selecting anything > from there. Documentation doesn't exist because the capability does not exist. It would be ridiculous to require a pre-query for every query to a database, which is why this hasn't come up in 8 years of Interchange supporting SQL databases. > And then it will have to either internally convert some > fields to latin1 OR it can use 'select cast' which can take care of > that as well. > > Well, basically, it'd be cool if I could write the query for the > locale database myself. How can I do that with Interchange? > > > Which software versions do you use (MySQL, Perl, DBI, DBD::mysql) ? > > 4.1, 5.8.6, 1.50, 3.0002(?) If they really did require a pre-query to return the proper data, it sounds like MySQL has changed the rules in a big way. I would be extremely surprised if this was really required. There must be a way to prevent it from munging this data without having to have a pre-query every time. Have you looked at DBI and MySQL documentation about this? -- Mike Heins Perusion -- Expert Interchange Consulting http://www.perusion.com/ phone +1.765.647.1295 tollfree 800-949-1889 <suppressed> Life may not be quite the party we hoped for, but while we are here we might as well dance. -- Anonymous _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.