{"id":38056,"date":"2026-01-22T14:00:42","date_gmt":"2026-01-22T11:00:42","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/"},"modified":"2026-01-22T14:00:42","modified_gmt":"2026-01-22T11:00:42","slug":"javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/","title":{"rendered":"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131"},"content":{"rendered":"<h2>JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131<\/h2>\n<p>G\u00fcn\u00fcm\u00fcz web uygulamalar\u0131nda kullan\u0131c\u0131 deneyimi ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fc kritik \u00f6neme sahiptir. Bu ba\u011flamda, kullan\u0131c\u0131 girdilerinin do\u011fru bir \u015fekilde i\u015flenmesi ve depolanmas\u0131, beklenmedik hatalar\u0131n \u00f6n\u00fcne ge\u00e7mek i\u00e7in elzemdir. \u00d6zellikle metin verileriyle \u00e7al\u0131\u015f\u0131rken, &#8220;karakter say\u0131m\u0131&#8221; gibi basit g\u00f6r\u00fcnen bir i\u015flem bile JavaScript, PHP ve MySQL gibi farkl\u0131 teknolojiler aras\u0131nda gizli tuzaklara yol a\u00e7abilir. Bu makalede, vekil \u00e7iftlerin (surrogate pairs) \u00f6tesine ge\u00e7erek, bu platformlar aras\u0131ndaki karakter say\u0131m\u0131 farkl\u0131l\u0131klar\u0131n\u0131, nedenlerini ve bu tuzaklardan nas\u0131l ka\u00e7\u0131naca\u011f\u0131m\u0131z\u0131 detayl\u0131ca inceleyece\u011fiz.<\/p>\n<h3>Karakter Kodlamalar\u0131na Derin Bir Bak\u0131\u015f: UTF-8 ve UTF-16<\/h3>\n<p>Metin i\u015fleme d\u00fcnyas\u0131nda karakter say\u0131m\u0131n\u0131n karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 anlamak i\u00e7in, \u00f6ncelikle karakter kodlamalar\u0131n\u0131n temellerini kavramak gerekir. \u00d6zellikle Unicode standard\u0131 ve onun pop\u00fcler uygulamalar\u0131 olan UTF-8 ve UTF-16, bu konunun merkezinde yer al\u0131r.<\/p>\n<h4>Unicode ve Kod Noktalar\u0131<\/h4>\n<p>Unicode, d\u00fcnya \u00fczerindeki t\u00fcm yaz\u0131m sistemlerini kapsayan evrensel bir karakter kodlama standard\u0131d\u0131r. Her karaktere benzersiz bir say\u0131sal de\u011fer atar; bu de\u011ferlere &#8220;kod noktas\u0131&#8221; (code point) denir. \u00d6rne\u011fin, &#8216;A&#8217; karakterinin kod noktas\u0131 U+0041, &#8216;\u20ac&#8217; sembol\u00fcn\u00fcn U+20AC, bir emoji olan &#8216;\ud83d\ude02&#8217; karakterinin ise U+1F602&#8217;dir. Kod noktalar\u0131 genellikle onalt\u0131l\u0131k (hexadecimal) olarak ifade edilir.<\/p>\n<h4>UTF-8: Web&#8217;in Tercihi<\/h4>\n<p>UTF-8 (Unicode Transformation Format &#8211; 8-bit), web \u00fczerinde en yayg\u0131n kullan\u0131lan karakter kodlamas\u0131d\u0131r. De\u011fi\u015fken uzunluklu bir kodlama \u015femas\u0131d\u0131r; yani bir karakteri temsil etmek i\u00e7in 1 ila 4 bayt aras\u0131nda de\u011fi\u015fen bir uzunluk kullanabilir. ASCII karakterleri (U+0000&#8217;dan U+007F&#8217;e kadar) tek bayt ile temsil edilirken, di\u011fer karakterler 2, 3 veya 4 bayt kullan\u0131r. Bu de\u011fi\u015fken uzunluklu yap\u0131s\u0131, hem geriye d\u00f6n\u00fck uyumluluk (ASCII ile) hem de alan verimlili\u011fi (\u00f6zellikle Bat\u0131 dillerinde) sa\u011flar.<\/p>\n<h4>UTF-16: JavaScript&#8217;in Dahili Standard\u0131<\/h4>\n<p>UTF-16 (Unicode Transformation Format &#8211; 16-bit), JavaScript&#8217;in dahili olarak stringleri temsil etmek i\u00e7in kulland\u0131\u011f\u0131 kodlamad\u0131r. Bu kodlamada, \u00e7o\u011fu karakter (Basic Multilingual Plane &#8211; BMP olarak adland\u0131r\u0131lan U+0000&#8217;dan U+FFFF&#8217;e kadar olan aral\u0131ktaki karakterler) 2 bayt (bir &#8220;kod birimi&#8221; &#8211; code unit) ile temsil edilir. Ancak, BMP d\u0131\u015f\u0131ndaki karakterler (supplementary characters, \u00f6rne\u011fin \u00e7o\u011fu emoji ve nadir \u00c7ince karakterler) iki adet 16-bitlik kod birimi kullan\u0131larak temsil edilir; bunlara &#8220;vekil \u00e7iftler&#8221; (surrogate pairs) denir. Bu, JavaScript&#8217;in <code>length<\/code> \u00f6zelli\u011finin neden bazen yan\u0131lt\u0131c\u0131 sonu\u00e7lar verdi\u011finin ana nedenidir.<\/p>\n<h3>JavaScript&#8217;in Karakter Sayma Tuza\u011f\u0131: UTF-16 ve Vekil \u00c7iftler<\/h3>\n<p>JavaScript&#8217;te string uzunlu\u011funu \u00f6l\u00e7mek i\u00e7in genellikle <code>String.prototype.length<\/code> \u00f6zelli\u011fini kullan\u0131r\u0131z. Ancak bu \u00f6zellik, bekledi\u011fimiz gibi &#8220;g\u00f6rsel karakter&#8221; say\u0131s\u0131n\u0131 de\u011fil, stringin UTF-16 kod birimi say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Bu durum, \u00f6zellikle vekil \u00e7iftlerle kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131zda \u00f6nemli sorunlara yol a\u00e7ar.<\/p>\n<h4><code>String.prototype.length<\/code>&#8216;in Yan\u0131lt\u0131c\u0131 Davran\u0131\u015f\u0131<\/h4>\n<p>JavaScript&#8217;te bir stringin <code>length<\/code> \u00f6zelli\u011fi, o stringi olu\u015fturan 16-bitlik kod birimlerinin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. BMP i\u00e7indeki karakterler i\u00e7in bu genellikle g\u00f6rsel karakter say\u0131s\u0131yla e\u015fle\u015fir. Ancak, bir vekil \u00e7ift (iki adet 16-bitlik kod birimi) ile temsil edilen bir karakter i\u00e7in <code>length<\/code> \u00f6zelli\u011fi 2 d\u00f6nd\u00fcr\u00fcrken, biz tek bir karakter g\u00f6rmeyi bekleriz.<\/p>\n<pre><code class=\"language-javascript\">\/\/ BMP karakteri: Tek bir kod birimi\nconst str1 = \"Merhaba\";\nconsole.log(str1.length); \/\/ \u00c7\u0131kt\u0131: 7 (Do\u011fru)\n\n\/\/ Emoji: Vekil \u00e7ift (iki kod birimi)\nconst str2 = \"\ud83d\udc4b\"; \/\/ El sallayan emoji U+1F44B\nconsole.log(str2.length); \/\/ \u00c7\u0131kt\u0131: 2 (Yanl\u0131\u015f, tek bir karakter bekleriz)\n\n\/\/ Birden fazla emoji ve BMP karakteri\nconst str3 = \"Merhaba d\u00fcnya! \ud83d\udc4b\ud83c\udf0d\";\nconsole.log(str3.length); \/\/ \u00c7\u0131kt\u0131: 19 (Beklenen: 17)<\/pre>\n<p><\/code><br \/>\nYukar\u0131daki \u00f6rnekte <code>\ud83d\udc4b<\/code> ve <code>\ud83c\udf0d<\/code> emojileri iki\u015fer kod birimi olarak say\u0131ld\u0131\u011f\u0131 i\u00e7in toplam uzunluk yanl\u0131\u015f hesaplanm\u0131\u015ft\u0131r.<\/p>\n<h4>Do\u011fru Karakter Say\u0131m\u0131: Kod Noktas\u0131 Yakla\u015f\u0131m\u0131<\/h4>\n<p>JavaScript'te do\u011fru karakter say\u0131m\u0131 i\u00e7in, stringi kod noktalar\u0131na ay\u0131rmam\u0131z gerekir. Bunu yapman\u0131n modern ve g\u00fcvenilir yollar\u0131 vard\u0131r:<\/p>\n<p>1.  <strong>Spread Operat\u00f6r\u00fc (<code>...<\/code>) ile Array.from:<\/strong> Bu y\u00f6ntem, stringi Unicode kod noktalar\u0131na g\u00f6re ayr\u0131\u015ft\u0131r\u0131r ve her bir kod noktas\u0131n\u0131 bir dizi eleman\u0131 olarak d\u00f6nd\u00fcr\u00fcr. Dizinin uzunlu\u011fu, ger\u00e7ek karakter say\u0131s\u0131n\u0131 verir.<\/p>\n<pre><code class=\"language-javascript\">const str = \"Merhaba d\u00fcnya! \ud83d\udc4b\ud83c\udf0d\";\n    const charArray = [...str]; \/\/ ['M', 'e', 'r', 'h', 'a', 'b', 'a', ' ', 'd', '\u00fc', 'n', 'y', 'a', '!', ' ', '\ud83d\udc4b', '\ud83c\udf0d']\n    console.log(charArray.length); \/\/ \u00c7\u0131kt\u0131: 17 (Do\u011fru)\n\n    \/\/ Fonksiyon olarak\n    function getTrueLength(str) {\n        return [...str].length;\n    }\n    console.log(getTrueLength(\"\ud83d\udc4b\")); \/\/ \u00c7\u0131kt\u0131: 1\n    console.log(getTrueLength(\"Merhaba d\u00fcnya! \ud83d\udc4b\ud83c\udf0d\")); \/\/ \u00c7\u0131kt\u0131: 17<\/pre>\n<p><\/code><\/p>\n<p>2.  <strong><code>Intl.Segmenter<\/code> (Daha Geli\u015fmi\u015f):<\/strong> Bu API, dilbilimsel olarak do\u011fru \"grapheme cluster\" (kullan\u0131c\u0131 taraf\u0131ndan tek bir karakter olarak alg\u0131lanan birim) say\u0131m\u0131 i\u00e7in tasarlanm\u0131\u015ft\u0131r. \u00d6zellikle birle\u015fik karakterler (\u00f6rne\u011fin, '\u00e9' veya '\ud83d\udc68\u200d\ud83d\udc69\u200d\ud83d\udc67\u200d\ud83d\udc66' gibi s\u0131f\u0131r geni\u015flikli birle\u015ftiricilerle olu\u015fan emojiler) i\u00e7in daha do\u011fru sonu\u00e7lar verebilir.<\/p>\n<pre><code class=\"language-javascript\">const str4 = \"\ud83d\udc68\u200d\ud83d\udc69\u200d\ud83d\udc67\u200d\ud83d\udc66\"; \/\/ Aile emojisi, birden fazla kod noktas\u0131 ve ZWJ (Zero Width Joiner) i\u00e7erir\n    console.log(str4.length); \/\/ \u00c7\u0131kt\u0131: 11 (Yanl\u0131\u015f)\n    console.log([...str4].length); \/\/ \u00c7\u0131kt\u0131: 4 (Hala yanl\u0131\u015f, tek bir karakter gibi g\u00f6r\u00fcn\u00fcr)\n\n    const segmenter = new Intl.Segmenter('tr', { granularity: 'grapheme' });\n    const segments = [...segmenter.segment(str4)];\n    console.log(segments.length); \/\/ \u00c7\u0131kt\u0131: 1 (Do\u011fru)\n\n    \/\/ Fonksiyon olarak\n    function getGraphemeLength(str) {\n        const segmenter = new Intl.Segmenter('tr', { granularity: 'grapheme' });\n        return [...segmenter.segment(str)].length;\n    }\n    console.log(getGraphemeLength(\"\ud83d\udc68\u200d\ud83d\udc69\u200d\ud83d\udc67\u200d\ud83d\udc66\")); \/\/ \u00c7\u0131kt\u0131: 1\n    console.log(getGraphemeLength(\"Merhaba d\u00fcnya! \ud83d\udc4b\ud83c\udf0d\")); \/\/ \u00c7\u0131kt\u0131: 17<\/pre>\n<p><\/code><br \/>\n    <code>Intl.Segmenter<\/code> karma\u015f\u0131k durumlar i\u00e7in en do\u011fru yakla\u015f\u0131m\u0131 sunar.<\/p>\n<h3>PHP'de Karakter Say\u0131m\u0131 ve UTF-8'in N\u00fcanslar\u0131<\/h3>\n<p>PHP, stringleri dahili olarak bayt dizileri olarak ele al\u0131r. Bu durum, \u00f6zellikle \u00e7ok baytl\u0131 UTF-8 karakterleriyle \u00e7al\u0131\u015f\u0131rken dikkatli olunmas\u0131 gerekti\u011fi anlam\u0131na gelir. PHP'nin standart string fonksiyonlar\u0131 genellikle bayt tabanl\u0131 \u00e7al\u0131\u015f\u0131r.<\/p>\n<h4><code>strlen()<\/code> vs. <code>mb_strlen()<\/code><\/h4>\n<p>PHP'de string uzunlu\u011funu \u00f6l\u00e7mek i\u00e7in iki ana fonksiyon bulunur:<\/p>\n<p>1.  <strong><code>strlen()<\/code>:<\/strong> Bu fonksiyon, verilen stringin *bayt cinsinden* uzunlu\u011funu d\u00f6nd\u00fcr\u00fcr. UTF-8 gibi \u00e7ok baytl\u0131 kodlamalarda, bu fonksiyonun d\u00f6nd\u00fcrd\u00fc\u011f\u00fc de\u011fer ger\u00e7ek karakter say\u0131s\u0131yla e\u015fle\u015fmez.<\/p>\n<pre><code class=\"language-php\">$str1 = \"Merhaba\";\n    echo strlen($str1); \/\/ \u00c7\u0131kt\u0131: 7 (Do\u011fru)\n\n    $str2 = \"\u015fifre\"; \/\/ '\u015f' ve '\u00e7' gibi T\u00fcrk\u00e7e karakterler UTF-8'de 2 baytt\u0131r\n    echo strlen($str2); \/\/ \u00c7\u0131kt\u0131: 7 (Yanl\u0131\u015f, 5 karakter bekleriz)\n\n    $str3 = \"\ud83d\udc4b\"; \/\/ Emoji, UTF-8'de 4 baytt\u0131r\n    echo strlen($str3); \/\/ \u00c7\u0131kt\u0131: 4 (Yanl\u0131\u015f, 1 karakter bekleriz)<\/pre>\n<p><\/code><\/p>\n<p>2.  <strong><code>mb_strlen()<\/code>:<\/strong> \"Multibyte String\" (\u00e7ok baytl\u0131 string) fonksiyonlar\u0131n\u0131n bir par\u00e7as\u0131 olan <code>mb_strlen()<\/code>, karakter setini g\u00f6z \u00f6n\u00fcnde bulundurarak stringin *karakter cinsinden* uzunlu\u011funu d\u00f6nd\u00fcr\u00fcr. Bu, UTF-8 gibi kodlamalarla \u00e7al\u0131\u015f\u0131rken do\u011fru sonu\u00e7lar\u0131 elde etmek i\u00e7in kullan\u0131lmas\u0131 gereken fonksiyondur.<\/p>\n<pre><code class=\"language-php\">\/\/ Varsay\u0131lan karakter setini ayarlamak \u00f6nemlidir\n    mb_internal_encoding(\"UTF-8\");\n\n    $str1 = \"Merhaba\";\n    echo mb_strlen($str1); \/\/ \u00c7\u0131kt\u0131: 7 (Do\u011fru)\n\n    $str2 = \"\u015fifre\";\n    echo mb_strlen($str2); \/\/ \u00c7\u0131kt\u0131: 5 (Do\u011fru)\n\n    $str3 = \"\ud83d\udc4b\";\n    echo mb_strlen($str3); \/\/ \u00c7\u0131kt\u0131: 1 (Do\u011fru)\n\n    $str4 = \"Merhaba d\u00fcnya! \ud83d\udc4b\ud83c\udf0d\";\n    echo mb_strlen($str4); \/\/ \u00c7\u0131kt\u0131: 17 (Do\u011fru)<\/pre>\n<p><\/code><br \/>\n    <code>mb_strlen()<\/code> fonksiyonuna ikinci bir parametre olarak karakter seti de verilebilir: <code>mb_strlen($string, 'UTF-8')<\/code>. Bu, <code>mb_internal_encoding()<\/code> ayar\u0131ndan ba\u011f\u0131ms\u0131z olarak belirli bir kodlama ile \u00e7al\u0131\u015fmay\u0131 sa\u011flar ve daha g\u00fcvenli bir yakla\u015f\u0131md\u0131r.<\/p>\n<h4>PHP'de Karakter Seti Ayarlar\u0131<\/h4>\n<p>PHP'nin \u00e7ok baytl\u0131 string fonksiyonlar\u0131n\u0131n do\u011fru \u00e7al\u0131\u015fmas\u0131 i\u00e7in, kullan\u0131lan karakter setinin do\u011fru bir \u015fekilde ayarlanmas\u0131 \u00e7ok \u00f6nemlidir. Bu genellikle <code>mb_internal_encoding(\"UTF-8\");<\/code> ile yap\u0131l\u0131r ve uygulaman\u0131n ba\u015flang\u0131c\u0131nda bir kez \u00e7a\u011fr\u0131lmal\u0131d\u0131r. Ayr\u0131ca, <code>php.ini<\/code> dosyas\u0131nda <code>default_charset = \"UTF-8\"<\/code> ayar\u0131n\u0131n yap\u0131ld\u0131\u011f\u0131ndan emin olunmal\u0131d\u0131r.<\/p>\n<h3>MySQL ve Karakter Setleri: Collation'lar\u0131n Rol\u00fc<\/h3>\n<p>Veritabanlar\u0131, \u00f6zellikle MySQL, metin verilerini depolama ve i\u015fleme konusunda kendi kurallar\u0131na sahiptir. Karakter setleri ve collation'lar (s\u0131ralama kurallar\u0131), string uzunluklar\u0131n\u0131 ve kar\u015f\u0131la\u015ft\u0131rmalar\u0131n\u0131 do\u011frudan etkiler.<\/p>\n<h4><code>LENGTH()<\/code> vs. <code>CHAR_LENGTH()<\/code><\/h4>\n<p>MySQL'de string uzunlu\u011funu \u00f6l\u00e7mek i\u00e7in iki ana fonksiyon bulunur:<\/p>\n<p>1.  <strong><code>LENGTH()<\/code>:<\/strong> Bu fonksiyon, stringin *bayt cinsinden* uzunlu\u011funu d\u00f6nd\u00fcr\u00fcr. PHP'deki <code>strlen()<\/code> gibi, \u00e7ok baytl\u0131 karakter setlerinde ger\u00e7ek karakter say\u0131s\u0131n\u0131 vermez.<\/p>\n<p>2.  <strong><code>CHAR_LENGTH()<\/code>:<\/strong> Bu fonksiyon, stringin *karakter cinsinden* uzunlu\u011funu d\u00f6nd\u00fcr\u00fcr. Bu, PHP'deki <code>mb_strlen()<\/code> gibi, \u00e7ok baytl\u0131 karakter setleriyle \u00e7al\u0131\u015f\u0131rken do\u011fru karakter say\u0131s\u0131n\u0131 elde etmek i\u00e7in kullan\u0131lmas\u0131 gereken fonksiyondur.<\/p>\n<pre><code class=\"language-sql\">-- Varsay\u0131lan karakter seti utf8mb4 olan bir tablo varsayal\u0131m\nSELECT\n    LENGTH('Merhaba') AS byte_len_merhaba,\n    CHAR_LENGTH('Merhaba') AS char_len_merhaba,\n    LENGTH('\u015fifre') AS byte_len_sifre,\n    CHAR_LENGTH('\u015fifre') AS char_len_sifre,\n    LENGTH('\ud83d\udc4b') AS byte_len_emoji,\n    CHAR_LENGTH('\ud83d\udc4b') AS char_len_emoji,\n    LENGTH('Merhaba d\u00fcnya! \ud83d\udc4b\ud83c\udf0d') AS byte_len_full,\n    CHAR_LENGTH('Merhaba d\u00fcnya! \ud83d\udc4b\ud83c\udf0d') AS char_len_full;<\/pre>\n<p><\/code><\/p>\n<p><strong>\u00c7\u0131kt\u0131 Tablosu:<\/strong><\/p>\n<p>| byte_len_merhaba | char_len_merhaba | byte_len_sifre | char_len_sifre | byte_len_emoji | char_len_emoji | byte_len_full | char_len_full |<br \/>\n| :--------------- | :--------------- | :------------- | :------------- | :------------- | :------------- | :------------ | :------------ |<br \/>\n| 7                | 7                | 7              | 5              | 4              | 1              | 72            | 17            |<\/p>\n<p>G\u00f6r\u00fcld\u00fc\u011f\u00fc gibi, <code>CHAR_LENGTH()<\/code> do\u011fru karakter say\u0131s\u0131n\u0131 verirken, <code>LENGTH()<\/code> bayt say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. \u00d6zellikle T\u00fcrk\u00e7e karakterler ve emojilerde fark belirginle\u015fir.<\/p>\n<h4><code>utf8<\/code> vs. <code>utf8mb4<\/code>: Neden <code>utf8mb4<\/code> Kullanmal\u0131y\u0131z?<\/h4>\n<p>MySQL'in eski <code>utf8<\/code> karakter seti, asl\u0131nda tam bir UTF-8 uygulamas\u0131 de\u011fildir. Sadece 1 ila 3 bayt uzunlu\u011fundaki karakterleri destekler. Bu, 4 bayt uzunlu\u011fundaki karakterleri (\u00f6rne\u011fin, \u00e7o\u011fu emoji ve baz\u0131 nadir \u00c7ince\/Japonca karakterler) depolayamad\u0131\u011f\u0131 anlam\u0131na gelir. Bu karakterler depolanmaya \u00e7al\u0131\u015f\u0131ld\u0131\u011f\u0131nda ya hata verir ya da '?' ile de\u011fi\u015ftirilir.<\/p>\n<p><code>utf8mb4<\/code> ise, tam UTF-8 deste\u011fi sunar ve 1 ila 4 bayt uzunlu\u011fundaki t\u00fcm Unicode karakterlerini do\u011fru bir \u015fekilde depolayabilir. Modern uygulamalarda, veritaban\u0131, tablo ve s\u00fctun d\u00fczeyinde <strong>mutlaka <code>utf8mb4<\/code> karakter seti kullan\u0131lmal\u0131d\u0131r<\/strong>.<\/p>\n<pre><code class=\"language-sql\">-- Veritaban\u0131 olu\u015ftururken\nCREATE DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- Tablo olu\u015ftururken\nCREATE TABLE users (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    username VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,\n    bio TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci\n);\n\n-- Mevcut tabloyu ve s\u00fctunu de\u011fi\u015ftirmek i\u00e7in\nALTER DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\nALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\nALTER TABLE users MODIFY username VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;<\/pre>\n<p><\/code><br \/>\nCollation (<code>utf8mb4_unicode_ci<\/code> gibi), karakterlerin nas\u0131l s\u0131ralanaca\u011f\u0131n\u0131 ve kar\u015f\u0131la\u015ft\u0131r\u0131laca\u011f\u0131n\u0131 belirler. <code>_ci<\/code> (case insensitive) b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyars\u0131zl\u0131\u011f\u0131 anlam\u0131na gelir.<\/p>\n<h3>Senkronizasyon Zorluklar\u0131 ve \u00c7\u00f6z\u00fcm Stratejileri<\/h3>\n<p>Frontend (JavaScript), Backend (PHP) ve Veritaban\u0131 (MySQL) aras\u0131nda karakter say\u0131m\u0131 konusunda tutars\u0131zl\u0131klar ya\u015fanmas\u0131, veri b\u00fct\u00fcnl\u00fc\u011f\u00fc sorunlar\u0131na, kullan\u0131c\u0131 deneyimi hatalar\u0131na ve g\u00fcvenlik a\u00e7\u0131klar\u0131na yol a\u00e7abilir.<\/p>\n<h4>Frontend-Backend Uyumsuzluklar\u0131<\/h4>\n<p>Bir kullan\u0131c\u0131 JavaScript ile bir metin alan\u0131na 10 karakterlik bir limit oldu\u011funu d\u00fc\u015f\u00fcnerek giri\u015f yapabilir. Ancak bu metin PHP'ye ula\u015ft\u0131\u011f\u0131nda <code>mb_strlen<\/code> ile kontrol edildi\u011finde 10 karakterden fazla \u00e7\u0131kabilir (\u00f6rne\u011fin, JavaScript <code>length<\/code> 10 iken, metin 5 emoji i\u00e7eriyorsa <code>mb_strlen<\/code> 5 d\u00f6nd\u00fcr\u00fcr). Veya tam tersi, JavaScript <code>length<\/code> 10 iken, PHP <code>mb_strlen<\/code> 10'dan az d\u00f6nd\u00fcrebilir (e\u011fer metin sadece BMP karakterler i\u00e7eriyorsa). Bu durum, kullan\u0131c\u0131ya yanl\u0131\u015f geri bildirim verilmesine veya sunucu taraf\u0131nda beklenmedik kesilmelere neden olabilir.<\/p>\n<h4>Veri B\u00fct\u00fcnl\u00fc\u011f\u00fc ve Maksimum Uzunluk K\u0131s\u0131tlamalar\u0131<\/h4>\n<p>Veritaban\u0131nda bir <code>VARCHAR(255)<\/code> s\u00fctunu tan\u0131mlad\u0131\u011f\u0131n\u0131zda, bu 255 *karakter* anlam\u0131na gelir (e\u011fer <code>utf8mb4<\/code> kullan\u0131l\u0131yorsa). Ancak frontend'de JavaScript <code>length<\/code> ile kontrol etti\u011finizde, vekil \u00e7iftler nedeniyle 255 karakterden daha az metin girilmesine izin verebilirsiniz. Ya da tam tersi, JavaScript'in yanl\u0131\u015f say\u0131m\u0131 nedeniyle veritaban\u0131na 255 karakterden *daha fazla* karakter g\u00f6ndermeye \u00e7al\u0131\u015fabilirsiniz, bu da veri kesilmesine veya hata mesajlar\u0131na yol a\u00e7ar.<\/p>\n<h4>Tutarl\u0131 Bir Karakter Sayma Stratejisi<\/h4>\n<p>Bu sorunlar\u0131 a\u015fmak i\u00e7in, t\u00fcm katmanlarda tutarl\u0131 bir karakter sayma stratejisi benimsemek esast\u0131r:<\/p>\n<p>1.  <strong>Frontend (JavaScript):<\/strong> Kullan\u0131c\u0131ya g\u00f6sterilen karakter say\u0131s\u0131n\u0131 ve maksimum uzunluk kontrollerini yaparken, <code>[...str].length<\/code> veya <code>Intl.Segmenter<\/code> kullanarak do\u011fru Unicode karakter say\u0131s\u0131n\u0131 elde edin.<\/p>\n<pre><code class=\"language-javascript\">\/\/ Kullan\u0131c\u0131 girdisi i\u00e7in maksimum 10 karakter\n    const maxChars = 10;\n    const userInput = \"Hello\ud83d\udc4b\"; \/\/ length 7, ger\u00e7ek 6\n    if ([...userInput].length > maxChars) {\n        \/\/ Hata mesaj\u0131 g\u00f6ster\n    }<\/pre>\n<p><\/code><\/p>\n<p>2.  <strong>Backend (PHP):<\/strong> Frontend'den gelen verileri i\u015flerken ve veritaban\u0131na kaydetmeden \u00f6nce, <code>mb_strlen($string, 'UTF-8')<\/code> kullanarak karakter say\u0131s\u0131n\u0131 do\u011frulay\u0131n. Bu, veritaban\u0131 k\u0131s\u0131tlamalar\u0131yla uyumlu olmas\u0131n\u0131 sa\u011flar.<\/p>\n<pre><code class=\"language-php\">\/\/ Frontend'den gelen veri\n    $userInput = $_POST['text_input'];\n    $maxChars = 10;\n\n    mb_internal_encoding(\"UTF-8\"); \/\/ Veya mb_strlen'e ikinci parametre olarak ge\u00e7in\n\n    if (mb_strlen($userInput) > $maxChars) {\n        \/\/ Hata d\u00f6nd\u00fcr, veri \u00e7ok uzun\n    }\n    \/\/ Veritaban\u0131na kaydet<\/pre>\n<p><\/code><\/p>\n<p>3.  <strong>Veritaban\u0131 (MySQL):<\/strong> T\u00fcm veritaban\u0131, tablo ve s\u00fctunlar\u0131n\u0131z\u0131n <code>utf8mb4<\/code> karakter setini kulland\u0131\u011f\u0131ndan emin olun. <code>CHAR_LENGTH()<\/code> fonksiyonunu kullanarak veritaban\u0131 taraf\u0131nda da karakter uzunluklar\u0131n\u0131 kontrol edebilirsiniz, ancak genellikle backend kontrol\u00fc yeterlidir.<\/p>\n<pre><code class=\"language-sql\">-- S\u00fctun tan\u0131m\u0131\n    <code>user_comment<\/code> VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL<\/pre>\n<p><\/code><\/p>\n<h3>Sonu\u00e7<\/h3>\n<p>JavaScript, PHP ve MySQL aras\u0131ndaki karakter say\u0131m\u0131 farkl\u0131l\u0131klar\u0131, y\u00fczeyde basit g\u00f6r\u00fcnse de, derinlemesine incelendi\u011finde karma\u015f\u0131k ve yan\u0131lt\u0131c\u0131 tuzaklar bar\u0131nd\u0131r\u0131r. Vekil \u00e7iftler, \u00e7ok baytl\u0131 karakterler ve farkl\u0131 kodlama standartlar\u0131, bu platformlar\u0131n string uzunluklar\u0131n\u0131 farkl\u0131 yorumlamas\u0131na neden olur. Bu makalede ele ald\u0131\u011f\u0131m\u0131z gibi, JavaScript'te <code>String.prototype.length<\/code> yerine <code>[...str].length<\/code> veya <code>Intl.Segmenter<\/code> kullanmak, PHP'de <code>strlen()<\/code> yerine <code>mb_strlen()<\/code> kullanmak ve MySQL'de <code>utf8<\/code> yerine <code>utf8mb4<\/code> karakter setini benimsemek ve <code>CHAR_LENGTH()<\/code> fonksiyonunu kullanmak, bu gizli tuzaklardan ka\u00e7\u0131nman\u0131n anahtar\u0131d\u0131r. T\u00fcm uygulama katmanlar\u0131nda tutarl\u0131 bir Unicode karakter say\u0131m\u0131 stratejisi benimseyerek, veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayabilir, kullan\u0131c\u0131 deneyimini iyile\u015ftirebilir ve beklenmedik hatalar\u0131n \u00f6n\u00fcne ge\u00e7ebilirsiniz. Bu konudaki fark\u0131ndal\u0131k ve do\u011fru ara\u00e7lar\u0131n kullan\u0131m\u0131, modern web geli\u015ftirmenin vazge\u00e7ilmez bir par\u00e7as\u0131d\u0131r.<\/p>\n<h3>SSS (S\u0131k\u00e7a Sorulan Sorular)<\/h3>\n<h4>1. Neden JavaScript'in <code>length<\/code> \u00f6zelli\u011fi emojileri yanl\u0131\u015f say\u0131yor?<\/h4>\n<p>JavaScript, stringleri dahili olarak UTF-16 kod birimleri olarak saklar. \u00c7o\u011fu emoji, Unicode'un \"Supplementary Plane\" b\u00f6lgesinde yer al\u0131r ve UTF-16'da iki adet 16-bitlik kod birimi (vekil \u00e7ift) ile temsil edilir. <code>String.prototype.length<\/code> ise bu kod birimlerinin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrd\u00fc\u011f\u00fc i\u00e7in, tek bir emoji i\u00e7in 2 d\u00f6nd\u00fcr\u00fcr.<\/p>\n<h4>2. PHP'de <code>strlen()<\/code> yerine neden <code>mb_strlen()<\/code> kullanmal\u0131y\u0131m?<\/h4>\n<p><code>strlen()<\/code> fonksiyonu, stringin bayt cinsinden uzunlu\u011funu d\u00f6nd\u00fcr\u00fcr. UTF-8 gibi \u00e7ok baytl\u0131 karakter kodlamalar\u0131nda, bir karakter birden fazla bayt ile temsil edilebilir (\u00f6rne\u011fin, T\u00fcrk\u00e7e '\u015f' veya emojiler). Bu durumda <code>strlen()<\/code> ger\u00e7ek karakter say\u0131s\u0131n\u0131 de\u011fil, bayt say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <code>mb_strlen()<\/code> ise belirtilen karakter setine g\u00f6re karakter say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrerek do\u011fru sonucu verir.<\/p>\n<h4>3. MySQL'de <code>utf8<\/code> ve <code>utf8mb4<\/code> aras\u0131ndaki fark nedir? Hangisini kullanmal\u0131y\u0131m?<\/h4>\n<p>MySQL'in eski <code>utf8<\/code> karakter seti, sadece 1 ila 3 bayt uzunlu\u011fundaki UTF-8 karakterlerini destekler. Bu, \u00e7o\u011fu emojinin ve baz\u0131 nadir Unicode karakterlerinin (4 bayt uzunlu\u011funda olanlar) depolanamamas\u0131 anlam\u0131na gelir. <code>utf8mb4<\/code> ise tam UTF-8 deste\u011fi sunar ve 1 ila 4 bayt uzunlu\u011fundaki t\u00fcm Unicode karakterlerini do\u011fru bir \u015fekilde depulayabilir. Modern uygulamalar i\u00e7in her zaman <code>utf8mb4<\/code> kullanmal\u0131s\u0131n\u0131z.<\/p>\n<h4>4. Frontend, Backend ve Veritaban\u0131 aras\u0131nda karakter say\u0131m\u0131 tutars\u0131zl\u0131klar\u0131 nas\u0131l \u00f6nlenir?<\/h4>\n<p>Her katmanda Unicode karakter say\u0131m\u0131n\u0131 do\u011fru bir \u015fekilde yapacak y\u00f6ntemleri kullanmal\u0131s\u0131n\u0131z: JavaScript'te <code>[...str].length<\/code> veya <code>Intl.Segmenter<\/code>, PHP'de <code>mb_strlen($string, 'UTF-8')<\/code> ve MySQL'de <code>utf8mb4<\/code> karakter seti ile <code>CHAR_LENGTH()<\/code> fonksiyonu. Ayr\u0131ca, t\u00fcm katmanlarda ayn\u0131 maksimum karakter uzunlu\u011fu limitlerini uygulayarak tutarl\u0131l\u0131\u011f\u0131 sa\u011flamal\u0131s\u0131n\u0131z.<\/p>\n<h4>5. Sadece \u0130ngilizce karakterlerle \u00e7al\u0131\u015f\u0131yorsam bu sorunlar beni etkiler mi?<\/h4>\n<p>E\u011fer uygulaman\u0131z sadece temel ASCII karakterlerle (\u0130ngilizce harfler, say\u0131lar, temel semboller) s\u0131n\u0131rl\u0131ysa, bu sorunlar sizi do\u011frudan etkilemeyebilir. Ancak, kullan\u0131c\u0131lar\u0131n emoji kullanma veya farkl\u0131 dillerde metin girme potansiyeli varsa (ki \u00e7o\u011fu modern web uygulamas\u0131nda bu ge\u00e7erlidir), bu konular\u0131 g\u00f6z \u00f6n\u00fcnde bulundurman\u0131z \u015fiddetle tavsiye edilir. Gelecekteki geni\u015flemeler veya uluslararas\u0131la\u015fma durumlar\u0131nda sorun ya\u015famamak i\u00e7in ba\u015ftan do\u011fru yakla\u015f\u0131mlar\u0131 benimsemek en iyisidir.<\/p>\n","protected":false},"excerpt":{"rendered":"JavaScript, stringleri dahili olarak UTF-16 kod birimleri olarak saklar. \u00c7o\u011fu emoji, Unicode&#8217;un &#8220;Supplementary Plane&#8221; b\u00f6lgesinde yer al\u0131r ve UTF-16&#8217;da ik&#8230;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[138],"tags":[],"class_list":{"0":"post-38056","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131\" \/>\n<meta property=\"og:description\" content=\"JavaScript, stringleri dahili olarak UTF-16 kod birimleri olarak saklar. \u00c7o\u011fu emoji, Unicode&#039;un &quot;Supplementary Plane&quot; b\u00f6lgesinde yer al\u0131r ve UTF-16&#039;da ik...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-22T11:00:42+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131\",\"datePublished\":\"2026-01-22T11:00:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/\"},\"wordCount\":2128,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"MySQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/\",\"name\":\"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-01-22T11:00:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/","og_locale":"tr_TR","og_type":"article","og_title":"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131","og_description":"JavaScript, stringleri dahili olarak UTF-16 kod birimleri olarak saklar. \u00c7o\u011fu emoji, Unicode'un \"Supplementary Plane\" b\u00f6lgesinde yer al\u0131r ve UTF-16'da ik...","og_url":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-01-22T11:00:42+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"14 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131","datePublished":"2026-01-22T11:00:42+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/"},"wordCount":2128,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["MySQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/","url":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/","name":"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-01-22T11:00:42+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/javascript-php-ve-mysql-arasinda-gizli-tuzaklar-vekil-ciftlerin-otesinde-karakter-sayimi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"JavaScript, PHP ve MySQL Aras\u0131nda Gizli Tuzaklar: Vekil \u00c7iftlerin \u00d6tesinde Karakter Say\u0131m\u0131"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/38056","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=38056"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/38056\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=38056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=38056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=38056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}