CHARACTER SET utf8

Submitted by Guest on Wed, 25/03/2009 - 02:56

General User's Discussion

hi !
Can I use character set UTF8 for writing data in MySQL BD?
I'm from Bulgaria and I like to write with no english letters!

Re: CHARACTER SET utf8

Submitted by tanderson on Wed, 25/03/2009 - 12:01.

MySQL is set up to use UTF8 by default.

Are you having issues using non-english characters?

-Tim

dr.st.todorov@mail.bg wrote:

> hi ! > Can I use character set UTF8 for writing data in MySQL BD? > I'm from Bulgaria and I like to write with no english letters! >

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu

CHARACTER SET utf8

Submitted by stanislav (not verified) on Wed, 25/03/2009 - 18:31.

I can write in Bulgarian characters when I make new patient, for example, end everythings is ok , but when I take this

patients from list of patients the letters is "????????,???????"

Re: Re: CHARACTER SET utf8

Submitted by tanderson on Wed, 25/03/2009 - 22:01.

dr.st.todorov@mail.bg wrote:

> I can write in Bulgarian characters when I make new patient, for > example, end everythings is ok , but when I take this patients from > list of patients the letters is "????????,???????"

What browser are you using? There are apparently issues displaying Cyrillic fonts in Firefox 2, according to the following page:

http://support.mozilla.com/tiki-view_forum_thread.php?comments_parentId=6727&forumId=1 These are reported to have been fixed in Firefox 3.

-Tim _______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu

character set utf8

Submitted by atwong (not verified) on Fri, 01/05/2009 - 13:39.

Hmm.. I'm trying to write in chinese characters with Firefox 3 and I get the same issues.

Re: character set utf8

Submitted by tanderson on Fri, 01/05/2009 - 14:00.

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

-Tim

albert@vetanyware.com wrote:

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

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu

Re: character set utf8

Submitted by atwong (not verified) on Fri, 01/05/2009 - 15:00.

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=utf8default-collation=utf8_unicode_ci[client]default-character-set=utf8

On Thu, Apr 30, 2009 at 7:43 PM, Tim Anderson <tma@netspace.net.au> wrote:

1. Make sure your database is configured to support UTF8. 2. Try a different browser. -Tim albert@vetanyware.com wrote:

Hmm.. I'm trying to write in chinese characters with Firefox 3 and I get the same issues. _______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: //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- //tinyurl.com/openvfu" target="_blank">http://tinyurl.com/openvfu

-- Albert T. WongVetAnyware, Veterinary Business Software Solutions

Re: character set utf8

Submitted by tanderson on Fri, 01/05/2009 - 16:00.

//W3C//DTD HTML 4.01 Transitional//EN"> If you use the release distribution, it is configured to use UTF8 by default. -Tim Albert T. Wong wrote:

cite="mid:a5abc1870904302024w32ca80e0ia27be9329afda3@mail.gmail.com" type="cite">
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">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 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

Re: character set utf8

Submitted by Tony De Keizer (not verified) on Fri, 01/05/2009 - 16:00.

Re: [OpenVPMS Users] character set utf8 Hi Albert, Yes, I was just about to say that all databases I have deployed using the documented release process have always had this set. Cheers Tony On 1/05/09 2:51 PM, "Tim Anderson" :

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 <tma@netspace.net.au> wrote:
1. Make sure your database is configured to support UTF8. 2. Try a different browser. -Tim albert@vetanyware.com wrote:
Hmm.. I'm trying to write in chinese characters with Firefox 3 and I get the same issues. _______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: //lists.openvpms.org/listinfo/users">http://lists.openvpms.org/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- //tinyurl.com/openvfu">http://tinyurl.com/openvfu

CHARACTER SET utf8

Comment viewing options