WordPress.org

Support

Support » Plugins and Hacks » Hacks » [Resolved] Problem with non latin characters

[Resolved] Problem with non latin characters

  • Jacob N. Breetvelt
    Participant

    @opajaap

    When i store this: ğ ü ş ç ö ı . in a post, you will see this: ğ ü ş ç ö ı .

    When i store this: ğ ü ş ç ö ı . in my db table (via $wpdb->prepare()), you will see: ? ü ? ç ö ? .

    The above in the same wp installation.

    I verified with js alert() that i get the correct data via $_POST.
    If i ommit prepare() and put it raw into an update query, the result is also wrong.

    My plugin is wp-photo-album-plus, The db tables are as follows:

    $create_albums = "CREATE TABLE " . ALBUM_TABLE . " (
                        id bigint(20) NOT NULL auto_increment,
                        name text NOT NULL,
                        description text NOT NULL,
                        a_order smallint(5) unsigned NOT NULL,
                        main_photo bigint(20) NOT NULL,
                        a_parent bigint(20) NOT NULL,
                        p_order_by int unsigned NOT NULL,
    					cover_linkpage bigint(20) NOT NULL,
                        PRIMARY KEY  (id)
                        );";
    
    	$create_photos = "CREATE TABLE " . PHOTO_TABLE . " (
                        id bigint(20) NOT NULL auto_increment,
                        album bigint(20) NOT NULL,
                        ext tinytext NOT NULL,
                        name text NOT NULL,
                        description longtext NOT NULL,
                        p_order smallint(5) unsigned NOT NULL,
                        PRIMARY KEY  (id)
                        );";
    
        require_once(ABSPATH . 'wp-admin/upgrade-functions.php');
    
        dbDelta($create_albums);
        dbDelta($create_photos);

    The fields afected are: name and description.

    What do i do wrong?

    I checked all possible character manipulating and escaping routines but could not find anything that converts multi-byte UTF-8 to &#12345 or something like that.

    Please help me supporting my Turkish users…

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘[Resolved] Problem with non latin characters’ is closed to new replies.