Alright I've checked the solution You gave me and everything seems to be working alright. I used MySQL installer for Windows and during installation wizard I've chosen "UTF8" as a standard charset. Database accepts polish and spanish fonts without a problem and they are properly displayed on website.
Great thanks! Best regards. mraible wrote: > > I don't think you need to change anything else. You can verify by > looking at the online demos: > > http://demo.appfuse.org > > Matt > > On 9/20/07, baterman <[EMAIL PROTECTED]> wrote: >> >> Alright I'll try to do that. Thanks for advice! There's one more question >> I >> would like to ask. Besides changing MYSQL settings, is there anything >> else I >> need to take care of in order to use Unicode fonts? >> >> Best regards. >> >> >> mraible wrote: >> > >> > I would suggest using the Windows Installer - it has a setup wizard >> > that allows you to set your default encoding to UTF-8. You also might >> > try creating the my.ini - I don't believe one exists by default. >> > >> > Matt >> > >> > On 9/20/07, baterman <[EMAIL PROTECTED]> wrote: >> >> >> >> Thx for such a quick reply! I've found that advice in FAQ on appfuse >> >> website >> >> but i couldn't locate "my.ini" in my Windows directory nor search did >> any >> >> results. I'm using "mysql-5.0.27-win32". I didn't install it, just >> >> unzipped >> >> it into my tools directory. >> >> >> >> Any other ideas, guys? >> >> >> >> Thanks in advance. >> >> Regards. >> >> >> >> >> >> mraible wrote: >> >> > >> >> > You might try adding the following to your c:\Windows\my.ini or >> >> > /etc/my.cnf file: >> >> > >> >> > [mysqld] >> >> > default-character-set=utf8 >> >> > >> >> > Then re-creating your database. >> >> > >> >> > Matt >> >> > >> >> > On 9/20/07, baterman <[EMAIL PROTECTED]> wrote: >> >> >> >> >> >> Hello! >> >> >> >> >> >> Currently I'm writing a web application which will help other >> people >> >> to >> >> >> learn foreign languages. I have the following question: what can I >> do >> >> to >> >> >> enable input of foreign fonts? When I try to type in some polish >> fonts >> >> >> from >> >> >> my webapp I get Hibernate exception, when I do that from SQLYog i >> get >> >> >> random letters displayed on website instead of appropriate ones. >> What >> >> >> should >> >> >> I do? I tried change MYSQL character set and collation to UTF8 by >> >> running >> >> >> command: >> >> >> >> >> >> mysqld --character-set-server=utf8 >> --collation-server=utf8_general_ci >> >> >> >> >> >> but it didn't work. In my application I use English, Polish, >> Spanish >> >> and >> >> >> German fonts, so I reckon UTF8 should be enough. >> >> >> >> >> >> Thanks for any kind of reply. >> >> >> Cheers! >> >> >> -- >> >> >> View this message in context: >> >> >> >> >> >> http://www.nabble.com/Problem-with-character-sets---fonts-tf4486819s2369.html#a12794872 >> >> >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> >> >> >> >> >> --------------------------------------------------------------------- >> >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> >> >> >> >> > >> >> > >> >> > -- >> >> > http://raibledesigns.com >> >> > >> >> > >> --------------------------------------------------------------------- >> >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> > For additional commands, e-mail: [EMAIL PROTECTED] >> >> > >> >> > >> >> > >> >> >> >> -- >> >> View this message in context: >> >> >> http://www.nabble.com/Problem-with-character-sets---fonts-tf4486819s2369.html#a12795874 >> >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> >> > >> > >> > -- >> > http://raibledesigns.com >> > >> > --------------------------------------------------------------------- >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> > For additional commands, e-mail: [EMAIL PROTECTED] >> > >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/Problem-with-character-sets---fonts-tf4486819s2369.html#a12796143 >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > > -- > http://raibledesigns.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Problem-with-character-sets---fonts-tf4486819s2369.html#a12802155 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
