Loading ...
Sorry, an error occurred while loading the content.
 

encoding problem with php-mySQL on linox

Expand Messages
  • duskfish2000
    Hi there I ve just immigrated a php CMS (drupal) from a windows server to a linox server. I copied the db files (mySQL) directly from one server to the other.
    Message 1 of 4 , Feb 27, 2006
      Hi there
      I've just immigrated a php CMS (drupal) from a windows server to a
      linox server. I copied the db files (mySQL) directly from one server
      to the other.
      I'm having an encoding problem eventhogh all db collation set all
      right. the db is encoded with hebrew_general_ci but what I'm getting
      is a mix of the right letters and squares (the letters are right and
      in there position but 90% of theme display as empty square - very
      strange !).

      I've copied my installation profile :

      PHP Version 4.3.11

      System Linux bzq-80-255-115.dcenter.bezeqint.net 2.6.15-
      1.1831_FC4smp #1 SMP Tue Feb 7 13:48:31 EST 2006 i686
      Build Date Nov 8 2005 06:25:44
      Configure Command './configure' '--build=i386-redhat-linux' '--
      host=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-
      prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--
      sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--
      includedir=/usr/include' '--libdir=/usr/lib' '--
      libexecdir=/usr/libexec' '--localstatedir=/var' '--
      sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--
      infodir=/usr/share/info' '--cache-file=../config.cache' '--with-
      config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--
      enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--
      disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-
      db4=/usr' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-
      dir=/usr' '--with-png-dir=/usr' '--with-gd=shared' '--enable-gd-
      native-ttf' '--without-gdbm' '--with-gettext' '--with-
      ncurses=shared' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '-
      -with-openssl' '--with-png' '--with-pspell' '--with-xml' '--with-
      expat-dir=/usr' '--with-dom=shared,/usr' '--with-dom-xslt=/usr' '--
      with-dom-exslt=/usr' '--with-xmlrpc=shared' '--with-pcre-
      regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--
      enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-
      sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-
      vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-
      pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl' '--with-
      kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-
      pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--
      enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-
      limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-
      dio' '--enable-mbstring=shared' '--enable-mbstr-enc-trans' '--enable-
      mbregex' '--with-mime-magic=/usr/share/file/magic.mime' '--with-
      pic' '--with-apxs2=/usr/sbin/apxs'
      Server API Apache 2.0 Handler
      Virtual Directory Support disabled
      Configuration File (php.ini) Path /etc/php.ini
      Scan this dir for additional .ini files /etc/php.d
      additional .ini files
      parsed /etc/php.d/gd.ini, /etc/php.d/imap.ini, /etc/php.d/mbstring.i
      ni, /etc/php.d/mysql.ini, /etc/php.d/xmlrpc.ini
      PHP API 20020918
      PHP Extension 20020429
      Zend Extension 20021010
      Debug Build no
      Thread Safety disabled
      Registered PHP Streams php, http, ftp, https, ftps, compress.bzip2,
      compress.zlib

      This program makes use of the Zend Scripting Language Engine:
      Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies


      ---------------------------------------------------------------------
      -----------

      PHP Credits

      ---------------------------------------------------------------------
      -----------

      Configuration
      PHP Core
      Directive Local Value Master Value
      allow_call_time_pass_reference Off Off
      allow_url_fopen On On
      always_populate_raw_post_data Off Off
      arg_separator.input & &
      arg_separator.output & &
      asp_tags Off Off
      auto_append_file no value no value
      auto_prepend_file no value no value
      browscap no value no value
      default_charset no value no value
      default_mimetype text/html text/html
      define_syslog_variables Off Off
      disable_classes no value no value
      disable_functions no value no value
      display_errors Off Off
      display_startup_errors Off Off
      doc_root no value no value
      docref_ext no value no value
      docref_root no value no value
      enable_dl On On
      error_append_string no value no value
      error_log no value no value
      error_prepend_string no value no value
      error_reporting 2047 2047
      expose_php On On
      extension_dir /usr/lib/php4 /usr/lib/php4
      file_uploads On On
      gpc_order GPC GPC
      highlight.bg #FFFFFF #FFFFFF
      highlight.comment #FF8000 #FF8000
      highlight.default #0000BB #0000BB
      highlight.html #000000 #000000
      highlight.keyword #007700 #007700
      highlight.string #DD0000 #DD0000
      html_errors On On
      ignore_repeated_errors Off Off
      ignore_repeated_source Off Off
      ignore_user_abort Off Off
      implicit_flush Off Off
      include_path .:/usr/share/pear .:/usr/share/pear
      log_errors On On
      log_errors_max_len 1024 1024
      magic_quotes_gpc Off Off
      magic_quotes_runtime Off Off
      magic_quotes_sybase Off Off
      max_execution_time 30 30
      max_input_time 60 60
      memory_limit 8M 8M
      open_basedir no value no value
      output_buffering no value no value
      output_handler no value no value
      post_max_size 8M 8M
      precision 14 14
      register_argc_argv On On
      register_globals Off Off
      report_memleaks On On
      safe_mode Off Off
      safe_mode_exec_dir no value no value
      safe_mode_gid Off Off
      safe_mode_include_dir no value no value
      sendmail_from no value no value
      sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
      serialize_precision 100 100
      short_open_tag On On
      SMTP localhost localhost
      smtp_port 25 25
      sql.safe_mode Off Off
      track_errors Off Off
      unserialize_callback_func no value no value
      upload_max_filesize 2M 2M
      upload_tmp_dir no value no value
      user_dir no value no value
      variables_order EGPCS EGPCS
      xmlrpc_error_number 0 0
      xmlrpc_errors Off Off
      y2k_compliance On On


      apache2handler
      Apache Version Apache/2.0.54 (Fedora)
      Apache API Version 20020903
      Server Administrator root@localhost
      Hostname:Port bzq-80-255-115.dcenter.bezeqint.net:0
      User/Group apache(48)/48
      Max Requests Per Child: 4000 - Keep Alive: off - Max Per
      Connection: 100
      Timeouts Connection: 120 - Keep-Alive: 15
      Virtual Server No
      Server Root /etc/httpd
      Loaded Modules core prefork http_core mod_so mod_access mod_auth
      mod_auth_anon mod_auth_dbm mod_auth_digest util_ldap mod_auth_ldap
      mod_include mod_log_config mod_logio mod_env mod_mime_magic
      mod_cern_meta mod_expires mod_deflate mod_headers mod_usertrack
      mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_asis
      mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir
      mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_proxy
      proxy_ftp proxy_http proxy_connect mod_cache mod_suexec
      mod_disk_cache mod_file_cache mod_mem_cache mod_cgi sapi_apache2

      Directive Local Value Master Value
      engine 1 1
      last_modified 0 0
      xbithack 0 0


      Apache Environment
      Variable Value
      HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
      application/x-shockwave-flash, application/vnd.ms-excel,
      application/vnd.ms-powerpoint, application/msword, */*
      HTTP_ACCEPT_LANGUAGE he
      HTTP_ACCEPT_ENCODING gzip, deflate
      HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;
      SV1)
      HTTP_HOST 82.80.255.115
      HTTP_CONNECTION Keep-Alive
      HTTP_COOKIE PHPSESSID=6d52c15cb2fe874bcf6b2dd149c4d0eb
      PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
      SERVER_SIGNATURE <address>Apache/2.0.54 (Fedora) Server at
      82.80.255.115 Port 80</address>
      SERVER_SOFTWARE Apache/2.0.54 (Fedora)
      SERVER_NAME 82.80.255.115
      SERVER_ADDR 82.80.255.115
      SERVER_PORT 80
      REMOTE_ADDR 192.117.126.2
      DOCUMENT_ROOT /var/www/html
      SERVER_ADMIN root@localhost
      SCRIPT_FILENAME /var/www/html/b.php
      REMOTE_PORT 2339
      GATEWAY_INTERFACE CGI/1.1
      SERVER_PROTOCOL HTTP/1.1
      REQUEST_METHOD GET
      QUERY_STRING no value
      REQUEST_URI /b.php
      SCRIPT_NAME /b.php


      HTTP Headers Information
      HTTP Request Headers
      HTTP Request GET /b.php HTTP/1.1
      Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
      application/x-shockwave-flash, application/vnd.ms-excel,
      application/vnd.ms-powerpoint, application/msword, */*
      Accept-Language he
      Accept-Encoding gzip, deflate
      User-Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
      Host 82.80.255.115
      Connection Keep-Alive
      Cookie PHPSESSID=6d52c15cb2fe874bcf6b2dd149c4d0eb
      HTTP Response Headers
      X-Powered-By PHP/4.3.11
      Connection close
      Transfer-Encoding chunked
      Content-Type text/html; charset=UTF-8


      bcmath
      BCMath support enabled


      bz2
      BZip2 Support Enabled
      BZip2 Version 1.0.2, 30-Dec-2001


      calendar
      Calendar support enabled


      ctype
      ctype functions enabled


      curl
      CURL support enabled
      CURL Information libcurl/7.13.1 OpenSSL/0.9.7f zlib/1.2.2.2
      libidn/0.5.15


      dba
      DBA support enabled
      Supported handlers cdb cdb_make db4 inifile flatfile


      dbx
      dbx support enabled
      dbx version 1.0.0
      supported databases MySQL ODBC PostgreSQL Microsoft SQL Server
      FrontBase Oracle 8 (oci8) Sybase-CT

      Directive Local Value Master Value
      dbx.colnames_case lowercase lowercase


      dio
      dio support enabled


      exif
      EXIF Support enabled
      EXIF Version 1.4 $Id: exif.c,v 1.118.2.37 2005/03/22 22:07:03 edink
      Exp $
      Supported EXIF Version 0220
      Supported filetypes JPEG,TIFF


      ftp
      FTP support enabled


      gd
      GD Support enabled
      GD Version bundled (2.0.28 compatible)
      FreeType Support enabled
      FreeType Linkage with freetype
      GIF Read Support enabled
      GIF Create Support enabled
      JPG Support enabled
      PNG Support enabled
      WBMP Support enabled
      XBM Support enabled


      gettext
      GetText Support enabled


      gmp
      gmp support enabled


      iconv
      iconv support enabled
      iconv implementation glibc
      iconv library version 2.3.5

      Directive Local Value Master Value
      iconv.input_encoding ISO-8859-1 ISO-8859-1
      iconv.internal_encoding ISO-8859-1 ISO-8859-1
      iconv.output_encoding ISO-8859-1 ISO-8859-1


      imap
      IMAP c-Client Version 2001
      SSL Support enabled
      Kerberos Support enabled


      mbstring
      Multibyte Support enabled
      Japanese support enabled
      Simplified chinese support enabled
      Traditional chinese support enabled
      Korean support enabled
      Russian support enabled
      Multibyte (japanese) regex support enabled

      mbstring extension makes use of "streamable kanji code filter and
      converter", which is distributed under the GNU Lesser General Public
      License version 2.1.

      Directive Local Value Master Value
      mbstring.detect_order no value no value
      mbstring.encoding_translation Off Off
      mbstring.func_overload 0 0
      mbstring.http_input pass pass
      mbstring.http_output pass pass
      mbstring.internal_encoding no value no value
      mbstring.language neutral neutral
      mbstring.substitute_character no value no value


      mime_magic
      mime_magic support enabled

      Directive Local Value Master Value
      mime_magic.magicfile /usr/share/file/magic.mime /usr/share/file/magic
      .mime


      mysql
      MySQL Support enabled
      Active Persistent Links 0
      Active Links 0
      Client API version 3.23.58
      MYSQL_MODULE_TYPE external
      MYSQL_SOCKET /var/lib/mysql/mysql.sock
      MYSQL_INCLUDE -I/usr/include/mysql
      MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

      Directive Local Value Master Value
      mysql.allow_persistent On On
      mysql.connect_timeout 60 60
      mysql.default_host no value no value
      mysql.default_password no value no value
      mysql.default_port no value no value
      mysql.default_socket no value no value
      mysql.default_user no value no value
      mysql.max_links Unlimited Unlimited
      mysql.max_persistent Unlimited Unlimited
      mysql.trace_mode Off Off


      openssl
      OpenSSL support enabled
      OpenSSL Version OpenSSL 0.9.7a Feb 19 2003


      overload
      User-Space Object Overloading Support enabled


      pcre
      PCRE (Perl Compatible Regular Expressions) Support enabled
      PCRE Library Version 5.0 13-Sep-2004


      posix
      Revision $Revision: 1.51.2.3 $


      pspell
      PSpell Support enabled


      session
      Session Support enabled
      Registered save handlers files user

      Directive Local Value Master Value
      session.auto_start Off Off
      session.bug_compat_42 Off Off
      session.bug_compat_warn On On
      session.cache_expire 180 180
      session.cache_limiter nocache nocache
      session.cookie_domain no value no value
      session.cookie_lifetime 0 0
      session.cookie_path / /
      session.cookie_secure Off Off
      session.entropy_file no value no value
      session.entropy_length 0 0
      session.gc_divisor 1000 1000
      session.gc_maxlifetime 1440 1440
      session.gc_probability 1 1
      session.name PHPSESSID PHPSESSID
      session.referer_check no value no value
      session.save_handler files files
      session.save_path /var/lib/php/session /var/lib/php/session
      session.serialize_handler php php
      session.use_cookies On On
      session.use_only_cookies Off Off
      session.use_trans_sid Off Off


      shmop
      shmop support enabled


      sockets
      Sockets Support enabled


      standard
      Regex Library Bundled library enabled
      Dynamic Library Support enabled
      Path to sendmail /usr/sbin/sendmail -t -i

      Directive Local Value Master Value
      assert.active 1 1
      assert.bail 0 0
      assert.callback no value no value
      assert.quiet_eval 0 0
      assert.warning 1 1
      auto_detect_line_endings 0 0
      default_socket_timeout 60 60
      safe_mode_allowed_env_vars PHP_ PHP_
      safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
      url_rewriter.tags
      a=href,area=href,frame=src,input=src,form=fakeentry
      a=href,area=href,frame=src,input=src,form=fakeentry
      user_agent no value no value


      tokenizer
      Tokenizer Support enabled


      wddx
      WDDX Support enabled
      WDDX Session Serializer enabled


      xml
      XML Support active
      XML Namespace Support active
      EXPAT Version expat_1.95.8


      xmlrpc
      core library version xmlrpc-epi v. 0.51
      php extension version 0.51
      author Dan Libby
      homepage http://xmlrpc-epi.sourceforge.net
      open sourced by Epinions.com


      yp
      YP Support enabled


      zlib
      ZLib Support enabled
      Compiled Version 1.2.1.2
      Linked Version 1.2.2.2

      Directive Local Value Master Value
      zlib.output_compression Off Off
      zlib.output_compression_level -1 -1
      zlib.output_handler no value no value


      Additional Modules
      Module Name
      sysvsem
      sysvshm


      Environment
      Variable Value
      LANG C
      TERM xterm
      PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
      PWD /
      SHLVL 1
      _ /usr/sbin/httpd


      PHP Variables
      Variable Value
      _REQUEST["PHPSESSID"] 6d52c15cb2fe874bcf6b2dd149c4d0eb
      _COOKIE["PHPSESSID"] 6d52c15cb2fe874bcf6b2dd149c4d0eb
      _SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg,
      image/pjpeg, application/x-shockwave-flash, application/vnd.ms-
      excel, application/vnd.ms-powerpoint, application/msword, */*
      _SERVER["HTTP_ACCEPT_LANGUAGE"] he
      _SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
      _SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0;
      Windows NT 5.1; SV1)
      _SERVER["HTTP_HOST"] 82.80.255.115
      _SERVER["HTTP_CONNECTION"] Keep-Alive
      _SERVER["HTTP_COOKIE"] PHPSESSID=6d52c15cb2fe874bcf6b2dd149c4d0eb
      _SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
      _SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.54 (Fedora) Server
      at 82.80.255.115 Port 80</address>
      _SERVER["SERVER_SOFTWARE"] Apache/2.0.54 (Fedora)
      _SERVER["SERVER_NAME"] 82.80.255.115
      _SERVER["SERVER_ADDR"] 82.80.255.115
      _SERVER["SERVER_PORT"] 80
      _SERVER["REMOTE_ADDR"] 192.117.126.2
      _SERVER["DOCUMENT_ROOT"] /var/www/html
      _SERVER["SERVER_ADMIN"] root@localhost
      _SERVER["SCRIPT_FILENAME"] /var/www/html/b.php
      _SERVER["REMOTE_PORT"] 2339
      _SERVER["GATEWAY_INTERFACE"] CGI/1.1
      _SERVER["SERVER_PROTOCOL"] HTTP/1.1
      _SERVER["REQUEST_METHOD"] GET
      _SERVER["QUERY_STRING"] no value
      _SERVER["REQUEST_URI"] /b.php
      _SERVER["SCRIPT_NAME"] /b.php
      _SERVER["PHP_SELF"] /b.php
      _SERVER["PATH_TRANSLATED"] /var/www/html/b.php
      _SERVER["argv"] Array
      (
      )

      _SERVER["argc"] 0
      _ENV["LANG"] C
      _ENV["TERM"] xterm
      _ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
      _ENV["PWD"] /
      _ENV["SHLVL"] 1
      _ENV["_"] /usr/sbin/httpd


      PHP License
      This program is free software; you can redistribute it and/or modify
      it under the terms of the PHP License as published by the PHP Group
      and included in the distribution in the file: LICENSE

      This program is distributed in the hope that it will be useful, but
      WITHOUT ANY WARRANTY; without even the implied warranty of
      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

      If you did not receive a copy of the PHP license, or have any
      questions about PHP licensing, please contact license@....
    • Oded Arbel
      ... *) copying the files directly is probably not a good idea - it might work, but a better idea would have been to dump the database to an SQL script and then
      Message 2 of 4 , Feb 27, 2006
        On Monday, 27 בFebruary 2006 17:13, duskfish2000 wrote:
        > Hi there
        > I've just immigrated a php CMS (drupal) from a windows server to a
        > linox server. I copied the db files (mySQL) directly from one server
        > to the other.
        > I'm having an encoding problem eventhogh all db collation set all
        > right. the db is encoded with hebrew_general_ci but what I'm getting
        > is a mix of the right letters and squares (the letters are right and
        > in there position but 90% of theme display as empty square - very
        > strange !).

        *) copying the files directly is probably not a good idea - it might
        work, but a better idea would have been to dump the database to an SQL
        script and then load it back to the other server.
        *) collation has nothing to do with the encoding of the data, only with
        sorting order.

        As to your actual problem - you probably have an issue where the
        encoding of the page that is displaying the data is not iso-8859-8
        (what is called in MySQL hebrew_general_ci), and the dump from
        phpinfo() is not helping to understand it.

        Instead try this - load the page, where the data isn't displayed
        properly, in your browser and right click on the page and choose "View
        Page Info". In the dialog that opens there should be a line saying
        "Encoding". I'm guessing it will say something like "UTF-8".
        (I'm assuming you are using some kind of Mozilla browser such as Firefox
        - if this is not the case, adapt the instructions to the browser that
        you are using).

        --
        Oded

        ::..
        "It is not enough to have great qualities, we should also have the
        management of them."
        -- La Rochefoucauld
      • duskfish2000
        HI Oded and thank you so much for your reply. I like to give some more information about my issue. My system is based on drupal CMS (drupal.org) and therefore
        Message 3 of 4 , Feb 28, 2006
          HI Oded and thank you so much for your reply.
          I like to give some more information about my issue.
          My system is based on drupal CMS (drupal.org) and therefore is based
          on UTF8 encoding. Pages are also automatically encoded with Unicode.
          2 other symptoms I noted are -
          1. Some time a loaded page displays empty page. A look in the code
          revile it got it all there but displaying nothing. Changing the
          encoding in this case to Hebrew (windows) will display the page but
          with wrong characters.
          2. The encoding issue act strange
          -
          ש׿׿ם ע׿׿׿ם ׿׿א׿׿ ׿ש׿׿ם
          -
          For
          שלום עליכם מלאכי ×"שלום
          Any ideas?

          TNX
          Fish





          --- In gnubies-il@yahoogroups.com, Oded Arbel <oded-gnubies@...>
          wrote:
          >
          > On Monday, 27 ×`February 2006 17:13, duskfish2000 wrote:
          > > Hi there
          > > I've just immigrated a php CMS (drupal) from a windows server to a
          > > linox server. I copied the db files (mySQL) directly from one
          server
          > > to the other.
          > > I'm having an encoding problem eventhogh all db collation set all
          > > right. the db is encoded with hebrew_general_ci but what I'm
          getting
          > > is a mix of the right letters and squares (the letters are right
          and
          > > in there position but 90% of theme display as empty square - very
          > > strange !).
          >
          > *) copying the files directly is probably not a good idea - it might
          > work, but a better idea would have been to dump the database to an
          SQL
          > script and then load it back to the other server.
          > *) collation has nothing to do with the encoding of the data, only
          with
          > sorting order.
          >
          > As to your actual problem - you probably have an issue where the
          > encoding of the page that is displaying the data is not iso-8859-8
          > (what is called in MySQL hebrew_general_ci), and the dump from
          > phpinfo() is not helping to understand it.
          >
          > Instead try this - load the page, where the data isn't displayed
          > properly, in your browser and right click on the page and choose
          "View
          > Page Info". In the dialog that opens there should be a line saying
          > "Encoding". I'm guessing it will say something like "UTF-8".
          > (I'm assuming you are using some kind of Mozilla browser such as
          Firefox
          > - if this is not the case, adapt the instructions to the browser
          that
          > you are using).
          >
          > --
          > Oded
          >
          > ::..
          > "It is not enough to have great qualities, we should also have the
          > management of them."
          > -- La Rochefoucauld
          >
        • Oded Arbel
          ... I couldn t read that - email does not transfer strange encodings well. Most likely you have an issue where the drupal thinks that all its data is utf-8,but
          Message 4 of 4 , Feb 28, 2006
            On Tuesday, 28 בFebruary 2006 15:28, duskfish2000 wrote:
            > HI Oded and thank you so much for your reply.
            > I like to give some more information about my issue.
            > My system is based on drupal CMS (drupal.org) and therefore is based
            > on UTF8 encoding. Pages are also automatically encoded with Unicode.
            > 2 other symptoms I noted are -
            > 1. Some time a loaded page displays empty page. A look in the code
            > revile it got it all there but displaying nothing. Changing the
            > encoding in this case to Hebrew (windows) will display the page but
            > with wrong characters.
            > 2. The encoding issue act strange

            I couldn't read that - email does not transfer strange encodings well.

            Most likely you have an issue where the drupal thinks that all its data
            is utf-8,but in your case the hebrew is encoded in windows-1255.

            You need to remember that for english text, utf-8 and any other 7 bit or
            8 bit encoding is exactly the same, so you can have the database store
            the the data in whatever encoding you like, and drupal would still
            display it well.

            Hebrew OTOH is encoded into different code points in windows-1255 and
            utf-8. Unless you're PHP code explicitly converts the encoding before
            display (using mbstring for example), then most likely you wont be able
            to display hebrew properly.

            My suggestion for you is to convert your database to utf-8.


            --
            Oded

            ::..
            The groundhog is like most other prophets; it delivers its message and
            then disappears.
          Your message has been successfully submitted and would be delivered to recipients shortly.