Thanks so much graff and others I now understand a little more about data types. may be my data is in wrong format in table. And i found that i also have some problems on communication between program and client as Burak advised me. For this encoding mismatch in communication, i used as "default-character-set=sjis" and " skip-character-set-client-handshake" in my.ini of mysql. Is this ok when i upload to some real hosting ? i convert like that and i used sjis to store data in database.Then, the query problem of "SELECT ... WHERE field1 LIKE "$input"."%"become OK since user input is also in sjis encoding. Anyway, i am really grateful for your good advises. i have some other related problem. this is to convert ascii character 'A' to sjis (japanese full-width alphanumeric character) 'Ａ' . But I am not sure that "the solution may be only known by the people who are working in japanese character" or such problem also exists in other unicode characters.

In reply to Re^2: how to change unicode string to byte array ? by nythu
in thread how to change unicode string to byte array ? by nythu

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.