Mike Heins wrote: > 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? > I found nothing in the docs and googling for this problem isn't encouraging either. Bye Racke _______________________________________________ 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.