//W3C//DTD HTML 4.01 Transitional//EN"> I should have said that the release distributions provided on the openvpms website are configured to use UTF8 by default. e.g //maven.openvpms.org/org.openvpms/zips/openvpms-release-1.3.zip">http://maven.openvpms.org/org.openvpms/zips/openvpms-release-1.3.zip The included createdb.sql and db.sql scripts will set up the database to use utf8. If you build the releases yourself, you'll need to configure my.ini as you have stated. -Tim Albert T. Wong wrote:

cite="mid:a5abc1870904302154s536846dfk6bfe36eab3200b23@mail.gmail.com" type="cite">

Hey Tim, Not sure.   I used the mysql package that pulled from yum centos repositories.   I don't think they were UTF8 by default and seems that other people have wrote a lot about latin1 being the default. href="http://www.google.com/search?q=mysql+latin1+to+utf8&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a">http://www.google.com/search?q=mysql+latin1+to+utf8&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

On Thu, Apr 30, 2009 at 9:51 PM, Tim Anderson < href="mailto:tma@netspace.net.au">tma@netspace.net.au> wrote:

style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">If you use the release distribution, it is configured to use UTF8 by default. -Tim

Albert T. Wong wrote:

By default, mysql uses latin1 instead of UTF8 to store data.  You need to add a configuration setting into your my.ini or my.cnf so that the server and client does everything by UTF8.

[mysqld] character-set-server=utf8 default-collation=utf8_unicode_ci [client] default-character-set=utf8

On Thu, Apr 30, 2009 at 7:43 PM, Tim Anderson < href="mailto:tma@netspace.net.au" target="_blank">tma@netspace.net.au> wrote:

style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

1. Make sure your database is configured to support UTF8. 2. Try a different browser. -Tim

target="_blank">albert@vetanyware.com wrote:

style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

Hmm.. I'm trying to write in chinese characters with Firefox 3 and I get the same issues. _______________________________________________ OpenVPMS User Mailing List href="mailto:users@lists.openvpms.org" target="_blank">users@lists.openvpms.org To unsubscribe or change your subscription visit: href="http://lists.openvpms.org/listinfo/users" target="_blank">http://lists.openvpms.org/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- href="http://tinyurl.com/openvfu" target="_blank">http://tinyurl.com/openvfu

-- Albert T. Wong VetAnyware, Veterinary Business Software Solutions

-- Albert T. Wong VetAnyware, Veterinary Business Software Solutions