Thank you so much for your time & the sample code. It is the same as
what I have except for
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="ja">
I added the above, but it does not fix the 'morphed' characters. It
helps immensely to know that you have the same environment & HTML/ASP as
I do. What does the "Transitional//EN" part in the above code do?
I understand the DOS prompt shows only junk text, but the data is ok. I
wish I could see it directly in MySQL to eliminate the possibility that
MySQL is morphing the characters and that this is a bug (unlikely I
know). Dumping it to a web page is where the problem crops up.
I guess now I have to figure out how to capture the data as it goes from
the web form through IIS to MyODBC to MySQL....and then back out again
from MySQL to MyODBC to IIS.
-----Original Message-----
From: Shashank Tripathi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 6:25 AM
To: Dawn Friedland; [EMAIL PROTECTED]
Subject: RE: Japanese Characters in MySQL & Win2k
Hi,
I think Joel Rees wrote an interesting message as well. Hope you read
it.
I run MySQL on Windows, SuSE 7.3 (Linux) and FreeBSD. Access it through
ASP/PHP/JSP/Perl DBI. There is no problem as far as I am concerned, it
works without a hitch.
If your default locale is EN, then you may see junk text in your MS DOS
prompt but rest assured, it is most likely the correct data -- it just
appears that way to you. Try dumping the same data onto a web page with
the following META tags:
<%@ Language=VBScript %>
<%
' Some OLEDB/ODBC code comes here
' to initialize a variable with your JP text
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="ja">
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=Shift_JIS">
....
</head>
<body>
<% Response.Write ("-----YOUR JP TEXT COMES HERE-----")
%>
</body>
</html>
That should do it.
Cheers,
Shanx
Shashank Tripathi
www.shanx.com
| -----Original Message-----
| From: Dawn Friedland [mailto:[EMAIL PROTECTED]]
| Sent: Wednesday, September 18, 2002 7:46 AM
| To: Shashank Tripathi; [EMAIL PROTECTED]
| Subject: RE: Japanese Characters in MySQL & Win2k
|
|
| Thank you Thank you.
|
| Are you running MySQL on Windows and using ASP on the web
| server?
|
| When I display the data after pulling it out, I use Shift_Jis.
|
| Yes, I mean the DOS prompt. My default language is
| English. I fear changing my locale because I wouldn't be
| able to change it back without a deepfry (I can't read
| Japanese!)
|
| -----Original Message-----
| From: Shashank Tripathi [mailto:[EMAIL PROTECTED]]
| Sent: Tuesday, September 17, 2002 3:36 PM
| To: Dawn Friedland; [EMAIL PROTECTED]
| Subject: RE: Japanese Characters in MySQL & Win2k
|
|
| Storing JP and EN data in the same table has worked for
| me ever since I started using MySQL. Unlike Oracle, you
| don't need any specific charset configs (I may stand
| corrected). The idea is to use the correct character
| encodings when you *display* the data after pulling it
| out. In your case, I'd think Shift_JIS.
|
| You mention displaying on the command line...u mean DOS
| prompt? If not, and if you meant some software, it shd be
| easy. If you meant DOS prompt, I guess it depends on what
| the default language in your windows box is. Do you have
| Japan set as your default locale and as the default
| language (Regional Options in Control Panel)? If so, the
| data shd display correctly without any additional effort.
|
| You can store EUC, Shift, ISO2022, and for that matter,
| Chinese in the same table in diff rows as well. During
| presentation time (display), just display using the
| appropriate encoding and it shd be ok.
|
| Holler if you need more help.
|
| Cheers,
| Shashank
|
|
|
|
|
|
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
