Problem with non latin characters
-
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…
- The topic ‘Problem with non latin characters’ is closed to new replies.