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 〹 or something like that.
Please help me supporting my Turkish users...
