Unicode UTF-8

View: New views
3 Messages — Rating Filter:   Alert me  

Unicode UTF-8

by Vladimir Drobnjak :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello to everybody!
I'm new to Knoda, so I don't know what to do to use unicode utf-8 charset with knoda's forms. My database is MySQL 5.0 and is set to utf8_unicode_ci. I like Knoda because is very user friendly (much more than OpenOfficeBase), but I can not use it for serious work because of these charset problems.

Thanks for any help!

--
Vladimir Drobnjak
Regional Archives of Koper
Slovenia
tel. +386-5-6271824
mobil. +386-51-418158
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hk-classes-discuss mailing list
Hk-classes-discuss@...
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss

Re: Unicode UTF-8

by robert leleu :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Vladimir Drobnjak skribis :

> Hello to everybody!
> I'm new to Knoda, so I don't know what to do to use unicode utf-8
> charset with knoda's forms. My database is MySQL 5.0 and is set to
> utf8_unicode_ci. I like Knoda because is very user friendly (much more
> than OpenOfficeBase), but I can not use it for serious work because of
> these charset problems.
>
> Thanks for any help!
>
>
I use UTF-8 Mysql database, and experiences no problem to see the datas
Nor hav I any problem to see UTF-8 labels in the forms.
However the use of UTF-8 in the messages is impossible, apparently
because of Python...From some discussions I only read in a french Python
forum, I should import something in Python, but at the time I have no
time to look after this topic.

Hoping I helped


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hk-classes-discuss mailing list
Hk-classes-discuss@...
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss

Re: Unicode UTF-8

by Willem Bogaerts :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> Hello to everybody!
> I'm new to Knoda, so I don't know what to do to use unicode utf-8 charset
> with knoda's forms. My database is MySQL 5.0 and is set to utf8_unicode_ci.
> I like Knoda because is very user friendly (much more than OpenOfficeBase),
> but I can not use it for serious work because of these charset problems.
>
> Thanks for any help!

I had the same problem. What basically happens is that Knoda (or better
said: the mysql driver) does not send a "SET NAMES utf8;" command
directly after opening a connection. Therefore, all characters are
reencoded, resulting in errors.

I could not find how to send a "SET NAMES utf8" by hand, as it is not an
update or select query. I stopped using Knoda for MySQL.

Best regards,
--
Willem Bogaerts

Applicatiesmid
Kratz B.V.
http://www.kratz.nl/

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hk-classes-discuss mailing list
Hk-classes-discuss@...
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss