[ic] UTF-8 in MySQL

Mike Heins mike at perusion.com
Tue Mar 7 14:47:38 EST 2006


Quoting Jon Jensen (jon at endpoint.com):
> On Tue, 7 Mar 2006, Elver Loho wrote:
> 
> >To get utf8 from MySQL's utf8 fields, *you have to tell MySQL that you
> >want it to 'convert' things to UTF-8 for you* This can be done using:
> >
> >1) set names utf8
> >2) set character set utf8
> >
> >Interchange will have to send either of those above commands before
> >executing 'select * from locale' in order to get proper utf8 strings
> >rather than the question marks it is getting now.
> >
> >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. 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.
> 
> I don't necessarily think doing this is the best solution for you, but 
> present it as something to consider:
> 
> Once upon a time I needed a certain session variable set in PostgreSQL 
> before a query was run (maybe timezone? I don't recall now), and added a 
> PREQUERY option to Interchange's databases, allowing something like this 
> in catalog.cfg:
> 
> Database  products  PREQUERY  "SET SESSION TIMEZONE TO 'EST5EDT'"
> 
> In the end, I decided to change the user's default settings so that the 
> timezone was like that automatically, and I never committed the change to 
> Interchange CVS. I've attached the patch -- it was written a long time 
> ago, so I hope that's everything you need to try it. If you find it 
> useful, let me know and we'll see about getting it in the core.

You would probably have to put this on a separate DSN, as I would think
it would affect all tables for the handle.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

When the only tool you have is a hammer, all your problems tend to look
like nails.  -- Abraham Maslow


More information about the interchange-users mailing list