Hi Almut,

Thank you very much for your reply. I decided to take the obscurity of the terminal window out of the picture and am now trying to generate it as a html page to view in Firefox.

This is all being done on Windows XP Professional.

At the moment I can do this with output to Firefox:

1) Using ASP and MS Access - OK!
2) Using ASP and MySQL - question marks.
3) Using Perl and MS Access - question marks.
4) Using Perl and MySQL - question marks.

So naturally I would like to do this with Perl and MySQL. When looking at the data in MySQL with a GUI like NaviCat I can see all the Japanese characters no worries. As part of the MySQL my.ini file i have amongst others, the following settings:

# The default character set that will be used when a new schema or table is created and no character set is defined
default-character-set=utf8

As part of the client section I have:

mysql

default-character-set=utf8

Also using something like 'MySQL Query Browser' I can again see the Japanese characters when I perform a simple query such as "SELECT kana, kanji FROM vocab".

I must admit a lot of what you said went straight over my head and I didn't really understand it.

I am sorry to say but I have no idea how to do this:
"To do so, let your perl program create HTML entity representations of the unicode characters, and embed those into some HTML page. For the purpose at hand, the ' ODEPOINT-IN-HEX;' form is easiest to generate."

Here is the code I am currently using: 

use DBI;
use CGI qw/:standard :html3/;
use CGI::Carp qw(fatalsToBrowser);

my $query = CGI -> new;

print header(-charset=>'utf-8');

my $dbh = DBI->connect('DBI:ODBC:japmysql','','') or die "Cannot conne
+ct: $DBI::errstr\n";

my $sth = $dbh->prepare('Select English, Kana, Kanji from Vocab')
    or die("Couldn't prepare");

$sth->execute or die ("Could not execute SQL statement.");

if($sth->rows == 0)
{
        print "No information.";
}
else
{
        
        print "<table border=1>\n";
        while( $resptr =  $sth->fetchrow_hashref() )
        {
                print "<tr>";
                print "<td>" . $resptr->{"English"};
                print "<td>" . $resptr->{"Kana"};
                print "<td>" . $resptr->{"Kanji"};                
                print "\n";
        }
        print "</table>\n";
}
print "</body></html>\n";

$dbh->disconnect;

[download]

Can you please show me what you mean using very short words? :)

Thanks again for all your help!

In reply to Re^2: MS Access Input -> Japanese Output by Zettai
in thread MS Access Input -> Japanese Output by Zettai

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.