WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Problem with non latin characters (2 posts)

  1. Jacob N. Breetvelt
    Member
    Posted 3 years ago #

    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...

  2. Jacob N. Breetvelt
    Member
    Posted 3 years ago #

    Fixed by:

    "ALTER TABLE " . ALBUM_TABLE . " MODIFY name text CHARACTER SET utf8"

    etc.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.