Jump to content


Photo

[SOLVED] japanese text


  • Please log in to reply
3 replies to this topic

#1 anatak

anatak
  • Members
  • PipPipPip
  • Advanced Member
  • 406 posts
  • LocationJapan, Fukuoka prefecture, Kitakyushu City

Posted 14 February 2006 - 11:11 AM

Hello,

I am trying to input japanese text into a mysql database.
I use Phpmyadmin to copy paste japanese text in the database.
I copy into a TEXT field. No matter what charset I try to use the text comes back as gibberish.

In another table I have text fields with mixed english and japanese text.
this text field is filled by a php script that writes the php string into the database.
with this text field I do not have the problem.

Does anybody know how to input japanese text directly into the db ?

I am getting more confused by the minute here.

thank you
anatak
takasi.8008@docomo.ne.jp
tourokum@0508.jp

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 14 February 2006 - 08:38 PM

It's all a matter of whether or not the input terminal supports non-ASCII characters, how how PHPMyAdmin deals with the TEXT field. Obviously, a script suffers from none of these problems.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 anatak

anatak
  • Members
  • PipPipPip
  • Advanced Member
  • 406 posts
  • LocationJapan, Fukuoka prefecture, Kitakyushu City

Posted 12 December 2007 - 12:27 AM

topic solved
solution use scripts and forms to input text into db

takasi.8008@docomo.ne.jp
tourokum@0508.jp

#4 chrisranjana.com

chrisranjana.com
  • Members
  • PipPip
  • Member
  • 14 posts
  • Locationchennai , tamil nadu , India

Posted 12 December 2007 - 09:22 AM

Do you have to define the character set in Mysql ?

Chris, Developer, Chrisranjana.com
Chennai, Tamil Nadu, India.
http://www.chrisranjana.com





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users