Loading ...
Sorry, an error occurred while loading the content.

printing kannada on web-page by using php and mysql

Expand Messages
  • basant sharma
    Hi Friends, I need to query mysql db and show the result text on web-page in Kannada language. But every time i am ending with ????? symbols. Here i am
    Message 1 of 5 , Oct 18, 2007
    • 0 Attachment
      Hi Friends,

      I need to query mysql db and show the result text on web-page in Kannada language. But every time i am ending with ????? symbols.
      Here i am writing the small application, which i am using.

      DB:
      ---------------------------
      CREATE TABLE `lang` (
      `sno` int(11) NOT NULL auto_increment,
      `text` varchar(20) character set utf8 default NULL,
      PRIMARY KEY (`sno`)
      ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

      --
      -- Dumping data for table `lang`
      --

      INSERT INTO `lang` VALUES (1, 'ಅಂತರ್ಜಾಲ');
      ------------------------------------------------------------
      PHP Code:
      --------------------------------------------------------------
      <html>
      <head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">

      </head>
      <body>
      <?php

      $con = mysql_connect('localhost','root','');
      mysql_select_db("test",$con);
      $rs=mysql_query('select text from lang', $con);
      echo mysql_result($rs,0,0);
      ?>
      </body>
      </html>
      --------------------------------------------------------
      My mysql varaibles :

      character set client
      utf8


      (Global value)
      latin1



      character set connection
      utf8


      (Global value)
      latin1



      character set database
      latin1



      character set filesystem
      binary



      character set results
      utf8


      (Global value)
      latin1



      character set server
      latin1



      character set system
      utf8



      character sets dir
      xxxxxx




      collation connection
      utf8_general_ci


      (Global value)
      latin1_general_ci



      collation database
      latin1_general_ci



      collation server
      latin1_general_ci-------------------------------------------------------------------------------

      Please help me with printing the above data to web-page in write format.
      Let me know where I am getting wrong.

      Thanks in advance.

      Basant.



      Vision without action is a daydream.
      Action without vision is a nightmare.




      Now you can chat without downloading messenger. Go to http://in.messenger.yahoo.com/webmessengerpromo.php

      [Non-text portions of this message have been removed]
    • Sumit Mittal
      you mysql table DEFAULT CHARSET is laitn should be utf8 only.. cheers, sumit ...
      Message 2 of 5 , Oct 18, 2007
      • 0 Attachment
        you mysql table DEFAULT CHARSET is laitn should be
        utf8 only..

        cheers,
        sumit

        --- basant sharma <vampirelovesu@...> wrote:

        > Hi Friends,
        >
        > I need to query mysql db and show the result text on
        > web-page in Kannada language. But every time i am
        > ending with ????? symbols.
        > Here i am writing the small application, which i am
        > using.
        >
        > DB:
        > ---------------------------
        > CREATE TABLE `lang` (
        > `sno` int(11) NOT NULL auto_increment,
        > `text` varchar(20) character set utf8 default
        > NULL,
        > PRIMARY KEY (`sno`)
        > ) ENGINE=MyISAM DEFAULT CHARSET=latin1
        > COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
        >
        > --
        > -- Dumping data for table `lang`
        > --
        >
        > INSERT INTO `lang` VALUES (1,
        > 'ಅಂತರ್ಜಾಲ');
        >
        ------------------------------------------------------------
        > PHP Code:
        >
        --------------------------------------------------------------
        > <html>
        > <head>
        > <meta http-equiv="Content-Type" content="text/html;
        > charset=utf-8">
        >
        > </head>
        > <body>
        > <?php
        >
        > $con = mysql_connect('localhost','root','');
        > mysql_select_db("test",$con);
        > $rs=mysql_query('select text from lang', $con);
        > echo mysql_result($rs,0,0);
        > ?>
        > </body>
        > </html>
        >
        --------------------------------------------------------
        > My mysql varaibles :
        >
        > character set client
        > utf8
        >
        >
        > (Global value)
        > latin1
        >
        >
        >
        > character set connection
        > utf8
        >
        >
        > (Global value)
        > latin1
        >
        >
        >
        > character set database
        > latin1
        >
        >
        >
        > character set filesystem
        > binary
        >
        >
        >
        > character set results
        > utf8
        >
        >
        > (Global value)
        > latin1
        >
        >
        >
        > character set server
        > latin1
        >
        >
        >
        > character set system
        > utf8
        >
        >
        >
        > character sets dir
        > xxxxxx
        >
        >
        >
        >
        > collation connection
        > utf8_general_ci
        >
        >
        > (Global value)
        > latin1_general_ci
        >
        >
        >
        > collation database
        > latin1_general_ci
        >
        >
        >
        > collation server
        >
        >
        latin1_general_ci-------------------------------------------------------------------------------
        >
        > Please help me with printing the above data to
        > web-page in write format.
        > Let me know where I am getting wrong.
        >
        > Thanks in advance.
        >
        > Basant.
        >
        >
        >
        > Vision without action is a daydream.
        > Action without vision is a nightmare.
        >
        >
        >
        >
        > Now you can chat without downloading
        > messenger. Go to
        > http://in.messenger.yahoo.com/webmessengerpromo.php
        >
        > [Non-text portions of this message have been
        > removed]
        >
        >
        >
        > Read Posting Guidelines at
        >
        http://groups.yahoo.com/group/in-phpug/files/guidelines.html
        >
        > Yahoo! Groups Links
        >
        >
        >
        >
        >


        __________________________________________________
        Do You Yahoo!?
        Tired of spam? Yahoo! Mail has the best spam protection around
        http://mail.yahoo.com
      • Ashish Jain
        check for the relevant font file on the system. ... [Non-text portions of this message have been removed]
        Message 3 of 5 , Oct 18, 2007
        • 0 Attachment
          check for the relevant font file on the system.

          On 10/18/07, basant sharma <vampirelovesu@...> wrote:
          >
          > Hi Friends,
          >
          > I need to query mysql db and show the result text on web-page in Kannada
          > language. But every time i am ending with ????? symbols.
          > Here i am writing the small application, which i am using.
          >
          > DB:
          > ---------------------------
          > CREATE TABLE `lang` (
          > `sno` int(11) NOT NULL auto_increment,
          > `text` varchar(20) character set utf8 default NULL,
          > PRIMARY KEY (`sno`)
          > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
          > AUTO_INCREMENT=2 ;
          >
          > --
          > -- Dumping data for table `lang`
          > --
          >
          > INSERT INTO `lang` VALUES (1, 'ಅಂತರ್ಜಾಲ');
          > ----------------------------------------------------------
          > PHP Code:
          > ----------------------------------------------------------
          > <html>
          > <head>
          > <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
          >
          > </head>
          > <body>
          > <?php
          >
          > $con = mysql_connect('localhost','root','');
          > mysql_select_db("test",$con);
          > $rs=mysql_query('select text from lang', $con);
          > echo mysql_result($rs,0,0);
          > ?>
          > </body>
          > </html>
          > --------------------------------------------------------
          > My mysql varaibles :
          >
          > character set client
          > utf8
          >
          >
          > (Global value)
          > latin1
          >
          >
          >
          > character set connection
          > utf8
          >
          >
          > (Global value)
          > latin1
          >
          >
          >
          > character set database
          > latin1
          >
          >
          >
          > character set filesystem
          > binary
          >
          >
          >
          > character set results
          > utf8
          >
          >
          > (Global value)
          > latin1
          >
          >
          >
          > character set server
          > latin1
          >
          >
          >
          > character set system
          > utf8
          >
          >
          >
          > character sets dir
          > xxxxxx
          >
          > collation connection
          > utf8_general_ci
          >
          >
          > (Global value)
          > latin1_general_ci
          >
          >
          >
          > collation database
          > latin1_general_ci
          >
          >
          >
          > collation server
          >
          > latin1_general_ci----------------------------------------------------------
          >
          > Please help me with printing the above data to web-page in write format.
          > Let me know where I am getting wrong.
          >
          > Thanks in advance.
          >
          > Basant.
          >
          > Vision without action is a daydream.
          > Action without vision is a nightmare.
          >
          > Now you can chat without downloading messenger. Go to
          > http://in.messenger.yahoo.com/webmessengerpromo.php
          >
          > [Non-text portions of this message have been removed]
          >
          >
          >


          [Non-text portions of this message have been removed]
        • pavi s
          ... If it is a local font problem he wouldnt have typed in kannada in the first place .. I think its the character set in the table as sumit said which is the
          Message 4 of 5 , Oct 18, 2007
          • 0 Attachment
            On 10/18/07, Ashish Jain <ashishjain.1983@...> wrote:
            >
            > check for the relevant font file on the system.
            >
            > .
            >
            >
            >
            If it is a local font problem he wouldnt have typed in kannada in the first
            place .. I think its the character set in the table as sumit said which is
            the problem


            [Non-text portions of this message have been removed]
          • Saravanan .R
            Hi basant sharma, I have seen your SQL Table. U have to set the UT8 for table. if ur using less than 4.1 mysql version. else u can set by column level. ...
            Message 5 of 5 , Oct 19, 2007
            • 0 Attachment
              Hi basant sharma,

              I have seen your SQL Table. U have to set the UT8 for table. if ur using less than 4.1 mysql version. else u can set by column level.

              ----- Original Message ----
              From: pavi s <pavi.eu@...>
              To: in-phpug@yahoogroups.com
              Sent: Thursday, 18 October, 2007 6:42:25 PM
              Subject: Re: [in-phpug] printing kannada on web-page by using php and mysql













              On 10/18/07, Ashish Jain <ashishjain.1983@ gmail.com> wrote:

              >

              > check for the relevant font file on the system.

              >

              > .

              >

              >

              >

              If it is a local font problem he wouldnt have typed in kannada in the first

              place .. I think its the character set in the table as sumit said which is

              the problem



              [Non-text portions of this message have been removed]














              <!--

              #ygrp-mkp{
              border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
              #ygrp-mkp hr{
              border:1px solid #d8d8d8;}
              #ygrp-mkp #hd{
              color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
              #ygrp-mkp #ads{
              margin-bottom:10px;}
              #ygrp-mkp .ad{
              padding:0 0;}
              #ygrp-mkp .ad a{
              color:#0000ff;text-decoration:none;}
              -->



              <!--

              #ygrp-sponsor #ygrp-lc{
              font-family:Arial;}
              #ygrp-sponsor #ygrp-lc #hd{
              margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
              #ygrp-sponsor #ygrp-lc .ad{
              margin-bottom:10px;padding:0 0;}
              -->



              <!--

              #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
              #ygrp-mlmsg table {font-size:inherit;font:100%;}
              #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
              #ygrp-mlmsg pre, code {font:115% monospace;}
              #ygrp-mlmsg * {line-height:1.22em;}
              #ygrp-text{
              font-family:Georgia;
              }
              #ygrp-text p{
              margin:0 0 1em 0;}
              #ygrp-tpmsgs{
              font-family:Arial;
              clear:both;}
              #ygrp-vitnav{
              padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
              #ygrp-vitnav a{
              padding:0 1px;}
              #ygrp-actbar{
              clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
              #ygrp-actbar .left{
              float:left;white-space:nowrap;}
              .bld{font-weight:bold;}
              #ygrp-grft{
              font-family:Verdana;font-size:77%;padding:15px 0;}
              #ygrp-ft{
              font-family:verdana;font-size:77%;border-top:1px solid #666;
              padding:5px 0;
              }
              #ygrp-mlmsg #logo{
              padding-bottom:10px;}

              #ygrp-vital{
              background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
              #ygrp-vital #vithd{
              font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
              #ygrp-vital ul{
              padding:0;margin:2px 0;}
              #ygrp-vital ul li{
              list-style-type:none;clear:both;border:1px solid #e0ecee;
              }
              #ygrp-vital ul li .ct{
              font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
              #ygrp-vital ul li .cat{
              font-weight:bold;}
              #ygrp-vital a{
              text-decoration:none;}

              #ygrp-vital a:hover{
              text-decoration:underline;}

              #ygrp-sponsor #hd{
              color:#999;font-size:77%;}
              #ygrp-sponsor #ov{
              padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
              #ygrp-sponsor #ov ul{
              padding:0 0 0 8px;margin:0;}
              #ygrp-sponsor #ov li{
              list-style-type:square;padding:6px 0;font-size:77%;}
              #ygrp-sponsor #ov li a{
              text-decoration:none;font-size:130%;}
              #ygrp-sponsor #nc{
              background-color:#eee;margin-bottom:20px;padding:0 8px;}
              #ygrp-sponsor .ad{
              padding:8px 0;}
              #ygrp-sponsor .ad #hd1{
              font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
              #ygrp-sponsor .ad a{
              text-decoration:none;}
              #ygrp-sponsor .ad a:hover{
              text-decoration:underline;}
              #ygrp-sponsor .ad p{
              margin:0;}
              o{font-size:0;}
              .MsoNormal{
              margin:0 0 0 0;}
              #ygrp-text tt{
              font-size:120%;}
              blockquote{margin:0 0 0 4px;}
              .replbq{margin:4;}
              -->








              Get the freedom to save as many mails as you wish. To know how, go to http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html

              [Non-text portions of this message have been removed]
            Your message has been successfully submitted and would be delivered to recipients shortly.