#1
  1. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    13
    Rep Power
    0
    Hi,
    I am trying to get a mySQL table to store Japanese characters. I don't need to see them , just need to retrieve the same thing I sent it. However right now mySQL just refuse to store the whole record at all.

    In a LINUX file, japanses appears in garbage like:
    ^[$B$K$[$s^[(B

    Why can't mySQL just store the same thing? How can I solve this problem?

    Thanks for your help in advance.
  2. #2
  3. No Profile Picture
    freebsd
    Guest
    Devshed Newbie (0 - 499 posts)
  4. #3
  5. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    13
    Rep Power
    0
    Thanks for your reply.

    But I think MySQL has Japanese support now: I have a directory /usr/share/mysql/japanese (and many other languages) that comes with the RPM installation of mySQL. I just dunno how to use it.
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Location
    Seoul, Corea
    Posts
    10
    Rep Power
    0
    Yon can recompile MySQL with characterset option.

    #./configure --prefix=/usr/local/mysql --with-charset=euc_jp

    ...

    #make

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 06:02 PM
  2. Writing Japanese unicode text to a mysql database
    By jayhay in forum PHP Development
    Replies: 3
    Last Post: January 13th, 2004, 08:10 AM
  3. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 12:35 PM
  4. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 12:27 AM
  5. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 03:16 AM

IMN logo majestic logo threadwatch logo seochat tools logo