## Using FusionCharts with RoR > UTF-8 Examples
In this section, we'll show you how to use FusionCharts and Ruby to plot charts from data containing UTF-8 characters. Using dataURL method we'll do the following: Create a column3D chart to show the Monthly Sales with data from a XML file. Create a pie chart to show "Production by Factory" data from the database. We'll use Japanese text in this example but you could extend it to any left-to-right language by applying the same procedure. Before you proceed with the contents in this page, we recommend you to go through the section "Basic Examples ". All code discussed here is present in Controller : Download Package > Code > RoR > SampleApp > app > fusioncharts > controllers > utf8_example_controller.rb. View : Download Package > Code > RoR > SampleApp > app > views > fusioncharts > utf8_example folder. View Helper Modules: Download Package > Code > RoR > SampleApp > lib > fusioncharts_helper.rb Plotting a chart with Japanese text from JapaneseData.xml While using FusionCharts with UTF-8 characters, please remember the following: dataURL method has to be used to get the xml. Rotated text cannot render UTF-8 characters. For example, UTF-8 characters in the rotated labels will not be rendered correctly. BOM has to present in the xml given as input to the chart. Setting up the charts for use In our code, we've used the charts contained in Download Package > Code > RoR > SampleApp > public >FusionCharts folder. When you run your samples, you need to make sure that the SWF files are in proper location. Also the JapaneseData.xml file used in japanese_xmlfile_example action is present in the Download Package > Code > RoR > public > Data folder. Let's now get to building our first example. In this example, we'll create a "Monthly Unit Sales" chart using dataURL method. For a start, we'll hard code our XML data in a physical XML document JapaneseData.xml, save it with UTF-8 encoding and then utilize it for our chart. Let's first have a look at the XML Data document: <?xml version="1.0" encoding="UTF-8" ?> <graph caption='月間販売' xAxisName='月' yAxisName='Units' decimalPrecision='0' formatNumberScale='0'> <set name='一月' value='462' color='AFD8F8' /> <set name='二月' value='857' color='F6BD0F' /> <set name='三月' value='671' color='8BBA00' /> <set name='四月' value='494' color='FF8E46' /> <set name='五月' value='761' color='008E8E' /> <set name='六月' value='960' color='D64646' /> <set name='七月' value='629' color='8E468E' /> <set name='八月' value='622' color='588526' /> <set name='九月' value='376' color='B3AA00' /> <set name='十月' value='494' color='008ED6' /> <set name='十一月' value='761' color='9D080D' /> <set name='十二月' value='960' color='A186BE' /> </graph> The XML document should begin with an XML declaration which specifies the version of XML being used and the encoding as seen in the above xml: <?xml version="1.0" encoding="UTF-8" ?> As you would notice, the caption, x-axisname and names of the months in the xml are in Japanese. Assuming that the Fusioncharts::Utf8ExampleController class has been created, we will define a function called japanese_xmlfile_example in this controller. The view used for this controller is the japanese_xmlfile_example.html.erb file. We will use the "common" layout for this view. It is important to have the <meta> tag in the head section of the html wih the charset defined as UTF-8 as shown below. This tag has been declared in the "common.html.erb" file, so that it is present in all the pages. <meta http-equiv="content-type" content="text/html; charset=utf-8" /> The code in the controller and view are given below. Controller: Fusioncharts::Utf8ExampleController Action: japanese_xmlfile_example class Fusioncharts::Utf8ExampleController < ApplicationController #This is an example showing Japanese characters on the chart. #Here, we've used a pre-defined JapaneseData.xml (contained in /Data/ folder) #This action uses the dataURL method of FusionCharts. #A view with the same name japanese_xmlfile_example.html.erb is present #and it is this view, which gets rendered with the layout "common". #render_chart function from the helper is invoked to render the chart. #The function itself has no code, all the work is done in the view. def japanese_xmlfile_example #The common layout for this view render(:layout => "layouts/common") end View: japanese_xmlfile_example.html.erb <% @page_title="FusionCharts Free - UTF8 日本語 (Japanese) Example" %> <% @page_heading="UTF8 日本語 (Japanese) Example" %> <% @page_subheading="Basic example using data from pre-built JapaneseData.xml" %> <% #Create the chart - Column 3D Chart with data from /Data/JapaneseData.xml render_chart "/FusionCharts/FCF_Column3D.swf", "/Data/JapaneseData.xml", "", "JapaneseChart", 600, 300, false, false do-%> <% end -%> The code in the controller action and the view page are similar to the basic example simple_chart action and its view simple_chart.html.erb. Only here, we have used some Japanese text. That's the effort involved in rendering UTF-8 characters on the chart! The chart with Japanese text will look as shown: Let' move on to our next example where we get the data from the database and dynamically create the xml. Plotting a chart with Japanese text from the database Let us now create a chart with UTF characters present in the database. For this we will modify the database and add table to contain the Japanese data. Database Configuration Please refer to Plotting From Database section for basic setup and configuration of the database. Ensure that the tables required for the UTF8 examples have been created. The required sql script "create_utfexample_tables_data.sql" is present in the Download Package > Code > RoR > SampleApp > db folder. You could run this script in your mysql, (if not already done)- this will alter the database to use UTF8 as default character set, create the japanese_factory_masters and french_factory_masters tables and insert sample data. Let's now shift our attention to the code that will interact with the database, fetch data and then render a chart. We will create an action japanese_dbexample, its .html.erb view, pie_data_japanese action and its corresponding pie_data_japanese view. The code contained in the controller action, view page are as shown: Controller: Fusioncharts::Utf8ExampleController Action: japanese_dbexample #In this example, we show how to use UTF8 characters in FusionCharts by connecting to a database #and using dataURL method. Here, the XML data #for the chart is generated in pie_data_japanese function. #The function itself does not contain any specific code to handle UTF8 characters. #NOTE: It's necessary to encode the dataURL if you've added parameters to it. def japanese_dbexample # Escape the URL using CGI.escape if it has parameters @str_data_url = "/Fusioncharts/utf8_example/pie_data_japanese" #The common layout for this view render(:layout => "layouts/common") end # Generates the xml with each factory's name and total output quantity. # Factory name in japanese is obtained from JapaneseFactoryMaster. # Content-type for its view is set to text/xml and char-set to UTF-8. def pie_data_japanese headers["Content-Type"] = "text/xml; charset=utf-8" # xml content with charset=uttf-8 @factory_data = [] # Find all the factories factory_masters = Fusioncharts::JapaneseFactoryMaster.find(:all) # For each factory, find the factory output details. factory_masters.each do |factory_master| factory_name = factory_master.name total = 0.0 factory_master.factory_output_quantities.each do |factory_output| # Total the output quantity for a particular factory total = total + factory_output.quantity end # Append the array of factory name and total output quantity to the existing array @factory_data @factory_data<<[factory_name,total] end end View: japanese_dbexample.html.erb <% @page_title="FusionCharts Free - UTF8 日本語 (Japanese) Database Example" %> <% @page_heading=" - UTF8 日本語 (Japanese) Example With Data from Database" %> <% @page_subheading="" %> <% #Create the chart - Pie 3D Chart with dataURL as @str_data_url. render_chart '/FusionCharts/FCF_Pie3D.swf',@str_data_url,'','FactorySum', 650, 450, false, false do-%> <% end -%> View: pie_data_japanese.html.erb <% str_xml = get_UTF8_BOM #Function present in fusioncharts_helper library str_xml +="<?xml version='1.0' encoding='UTF-8'?>" str_xml +="<graph caption='工場出力レポート' subCaption='数量面で' decimalPrecision='0' showNames='1' numberSuffix=' units' pieSliceDepth='30' formatNumberScale='0'>" for item in @factory_data str_xml += "<set name='"+item[0]+"' value='"+item[1].to_s+"'/>" end str_xml+="</graph>" #Create the chart - Pie 3D Chart with data from strXML %><%=str_xml%> The action japanese_db_example and its view japanese_db_example.html.erb are very similar to default action of Fusioncharts::DbDataUrlController and corresponding default.html.erb view. Here we have used Japanese text for page heading etc. There is no UTF specific changes that need to be done to this action and its view. Let's move on to the pie_data_japanese action and its view. In pie_data_japanese action we have set the header with right content-type and charset as shown: headers["Content-Type"] = "text/xml; charset=utf-8" We have used the JapaneseFactoryMaster to find the factory names in Japanese. In the view pie_data_japanese.html.erb, we have built the xml as a string using @factory_data present in the controller. The steps followed in this page are: Call the function get_UTF8_BOM from fusioncharts_helper and store it in str_xml. Append the XML declaration with encoding: <?xml version="1.0" encoding="UTF-8" ?> to str_xml. Append the actual xml content starting with the <graph> element. Output str_xml which contains the UTF8 BOM, XML declaration with encoding and the actual data xml. When we view the chart in the browser, it would look like this: In Download Package > Code > RoR > SampleApp > app > controllers > fusioncharts > utf8_example_controller.rb, we've more example codes for French language too, which have not been explained here, as they're similar in concept. You can directly see the code and get more insight into it.