Dear group,

I run Knoda on Xubuntu, which uses utf-8 as the native encoding.
However, for MySQL, no "SET NAMES utf8" is sent upon connection. This
means that the connection defaults to "latin1" (iso-8859-1). Knoda then
tries to render latin-1 data as if it were utf-8 encoded.

The nicest solution is to send the command "SET NAMES utf8" immediately
upon connection. This sounds simple, but I know it is not. I do not know
if it is easy to see what encoding the OS is running on, and alas every
encoding name has to be translated to MySQL identifiers (that is why
there are no minus characters in the encoding names in MySQL).
Furthermore, the SET NAMES command is only present in MySQL 4.1 and
higher (which can be read with "SELECT VERSION()", or probably a C
function).

I am using Knoda 0.8.3.

Best regards,
-- 
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss

Reply via email to