about unicode

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • ncix

    about unicode

    i have unicode support mysql database with data.
    how i can retrieve this data in php page i have tried using simple sql
    query but it shows only "?????????? ?" characters

    regards
    ncix

  • Emil

    #2
    Re: about unicode

    ncix napisał(a):[color=blue]
    > i have unicode support mysql database with data.
    > how i can retrieve this data in php page i have tried using simple sql
    > query but it shows only "?????????? ?" characters
    >
    > regards
    > ncix
    >[/color]
    You have to set client library encoding to unicode.
    E.g. mysql_query('SE T NAMES utf8') after every connection to database.
    You can check current encoding by calling mysql_get_clien t_encoding();
    And, of course check if the fields in database and web page have proper
    encoding.
    grtz. Emil

    Comment

    • ncix

      #3
      Re: about unicode


      Emil wrote:

      thanx, i solve it ........

      Comment

      • Haoyu Meng

        #4
        Re: about unicode


        u need to send the right html headers to indicate that the content is in
        utf-8



        ncix wrote:
        i have unicode support mysql database with data.
        how i can retrieve this data in php page i have tried using simple sql
        query but it shows only "?????????? ?" characters
        >
        regards
        ncix
        >
        >
        --
        Sell classified ad space on your website <http://www.junxter.net >

        Comment

        Working...