[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