{"id":25642,"date":"2025-07-10T09:15:23","date_gmt":"2025-07-10T06:15:23","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/"},"modified":"2025-07-10T09:15:23","modified_gmt":"2025-07-10T06:15:23","slug":"postgresql-varchar-turunu-booleana-donusturme","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/","title":{"rendered":"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme"},"content":{"rendered":"<p># PostgreSQL&#8217;de varchar&#8217;\u0131 Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme: Tam Bir K\u0131lavuz<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda metin t\u00fcr\u00fcnde (varchar) saklanan &#8220;evet\/hay\u0131r&#8221;, &#8220;do\u011fru\/yanl\u0131\u015f&#8221; gibi Boolean de\u011ferleri mi kullan\u0131yorsunuz?  Bu de\u011ferleri sorgulamak ve mant\u0131ksal i\u015flemlerde kullanmak i\u00e7in bunlar\u0131 Boolean t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmeniz gerekebilir. Bu makale, PostgreSQL&#8217;de varchar t\u00fcr\u00fcndeki verileri Boolean&#8217;a d\u00f6n\u00fc\u015ft\u00fcrmenin farkl\u0131 y\u00f6ntemlerini, potansiyel sorunlar\u0131 ve performans optimizasyonlar\u0131n\u0131 ad\u0131m ad\u0131m a\u00e7\u0131klayacakt\u0131r.  Veritaban\u0131 i\u015flemlerinizde daha verimli ve g\u00fcvenilir sonu\u00e7lar elde etmenize yard\u0131mc\u0131 olacak pratik \u00e7\u00f6z\u00fcmler sunaca\u011f\u0131z.<\/p>\n<p><strong>PostgreSQL&#8217;de varchar&#8217;\u0131 Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme: Temel Kavramlar<\/strong><\/p>\n<p>PostgreSQL, Boolean veri t\u00fcr\u00fcn\u00fc <code class=\"language-\">boolean<\/code> olarak tan\u0131mlar.  <code class=\"language-\">true<\/code> veya <code class=\"language-\">false<\/code> de\u011ferlerini alabilir.  Ancak, verileriniz <code class=\"language-\">varchar<\/code> t\u00fcr\u00fcnde saklan\u0131yorsa, do\u011frudan Boolean i\u015flemlerinde kullanamazs\u0131n\u0131z.  Bu nedenle, <code class=\"language-\">varchar<\/code> verilerini <code class=\"language-\">boolean<\/code>&#8216;a d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u00e7e\u015fitli y\u00f6ntemler kullanmal\u0131s\u0131n\u0131z.  Bu d\u00f6n\u00fc\u015ft\u00fcrme i\u015flemi s\u0131ras\u0131nda dikkat edilmesi gereken en \u00f6nemli nokta, <code class=\"language-\">varchar<\/code> s\u00fctununda tutulan de\u011ferlerin tutarl\u0131 ve beklendi\u011fi gibi olmas\u0131d\u0131r.  \u00d6rne\u011fin, &#8220;evet&#8221;, &#8220;1&#8221;, &#8220;true&#8221; gibi farkl\u0131 ifadeler Boolean <code class=\"language-\">true<\/code> olarak yorumlanabilirken,  &#8220;hay\u0131r&#8221;, &#8220;0&#8221;, &#8220;false&#8221; gibi ifadeler <code class=\"language-\">false<\/code> olarak yorumlanabilir.  Ancak, bu de\u011ferler tutars\u0131z bir \u015fekilde kullan\u0131l\u0131rsa, yanl\u0131\u015f sonu\u00e7lar elde edebilirsiniz.<\/p>\n<p><strong>PostgreSQL&#8217;de varchar&#8217;\u0131 Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme: Nas\u0131l Yap\u0131l\u0131r? (Yeni Ba\u015flayanlar \u0130\u00e7in)<\/strong><\/p>\n<p>Yeni ba\u015flayanlar i\u00e7in en basit yakla\u015f\u0131m, <code class=\"language-\">CASE<\/code> ifadesini kullanmakt\u0131r. Bu y\u00f6ntem, <code class=\"language-\">varchar<\/code> s\u00fctunundaki belirli de\u011ferleri <code class=\"language-\">boolean<\/code> de\u011ferlerine e\u015fler.<\/p>\n<p><strong>\u00d6rnek:<\/strong>  <code class=\"language-\">status<\/code> adl\u0131 <code class=\"language-\">varchar<\/code> s\u00fctununda &#8220;aktif&#8221; veya &#8220;pasif&#8221; de\u011ferleri sakland\u0131\u011f\u0131n\u0131 varsayal\u0131m.  Bunlar\u0131 <code class=\"language-\">boolean<\/code> t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u015fu sorguyu kullanabiliriz:<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    CASE\n        WHEN status = 'aktif' THEN TRUE\n        WHEN status = 'pasif' THEN FALSE\n        ELSE NULL -- Belirsiz durumlar i\u00e7in NULL d\u00f6nd\u00fcr\u00fcr\n    END AS aktif_mi\nFROM\n    my_table;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">status<\/code> s\u00fctunundaki &#8220;aktif&#8221; de\u011ferlerini <code class=\"language-\">TRUE<\/code> olarak, &#8220;pasif&#8221; de\u011ferlerini <code class=\"language-\">FALSE<\/code> olarak ve di\u011fer t\u00fcm de\u011ferleri <code class=\"language-\">NULL<\/code> olarak d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.  <code class=\"language-\">NULL<\/code> de\u011ferleri, verilerinizde beklenmedik de\u011ferler oldu\u011funda ortaya \u00e7\u0131kar ve bunlar\u0131 ele alman\u0131z \u00f6nemlidir.<\/p>\n<p><strong>PostgreSQL&#8217;de varchar&#8217;\u0131 Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme: Ger\u00e7ek D\u00fcnya \u00d6rne\u011fi (Orta Seviye)<\/strong><\/p>\n<p>Bir e-ticaret sitesinin m\u00fc\u015fteri sipari\u015flerini d\u00fc\u015f\u00fcnelim.  <code class=\"language-\">siparis_durumu<\/code> adl\u0131 bir <code class=\"language-\">varchar<\/code> s\u00fctununda &#8220;tamamland\u0131&#8221;, &#8220;iptal edildi&#8221;, &#8220;bekleniyor&#8221; gibi de\u011ferler saklan\u0131yor olsun.  Sadece &#8220;tamamland\u0131&#8221; durumundaki sipari\u015fleri filtrelemek i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabiliriz:<\/p>\n<pre class=\"language-sql\"><code>SELECT *\nFROM siparisler\nWHERE\n  CASE\n    WHEN siparis_durumu = 'tamamland\u0131' THEN TRUE\n    ELSE FALSE\n  END;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">siparis_durumu<\/code> s\u00fctununda &#8220;tamamland\u0131&#8221; de\u011feri olan t\u00fcm sat\u0131rlar\u0131 d\u00f6nd\u00fcr\u00fcr. Di\u011fer de\u011ferler <code class=\"language-\">FALSE<\/code> olarak de\u011ferlendirilece\u011finden filtrelenir.  Bu \u00f6rnek, ger\u00e7ek d\u00fcnya senaryolar\u0131nda <code class=\"language-\">varchar<\/code>&#8216;\u0131 <code class=\"language-\">boolean<\/code>&#8216;a d\u00f6n\u00fc\u015ft\u00fcrmenin ve bu d\u00f6n\u00fc\u015ft\u00fcrmeyi filtrelemede kullanman\u0131n nas\u0131l faydal\u0131 oldu\u011funu g\u00f6stermektedir.<\/p>\n<p><strong>PostgreSQL&#8217;de varchar&#8217;\u0131 Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme:  Optimizasyon \u0130pu\u00e7lar\u0131 (Orta Seviye)<\/strong><\/p>\n<p>Performans\u0131 art\u0131rmak i\u00e7in, m\u00fcmk\u00fcnse <code class=\"language-\">CASE<\/code> ifadesi yerine <code class=\"language-\">boolean<\/code> indeksleri kullanmay\u0131 d\u00fc\u015f\u00fcn\u00fcn.  E\u011fer <code class=\"language-\">varchar<\/code> s\u00fctununuzda sadece iki farkl\u0131 de\u011fer varsa (\u00f6rne\u011fin, &#8220;evet\/hay\u0131r&#8221;), bu de\u011ferleri do\u011frudan <code class=\"language-\">boolean<\/code> t\u00fcr\u00fcnde saklamak daha verimli olacakt\u0131r.  Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak i\u00e7in, veritaban\u0131 \u015femas\u0131n\u0131 de\u011fi\u015ftirmeden \u00f6nce verilerinizi iyice temizleyin ve tutarl\u0131 hale getirin.  Ayr\u0131ca,  <code class=\"language-\">CASE<\/code> ifadesinin i\u00e7indeki ko\u015fullar\u0131 optimize edebilirsiniz.  En s\u0131k kar\u015f\u0131la\u015f\u0131lan de\u011ferleri \u00f6nce kontrol ederek sorgunun performans\u0131n\u0131 art\u0131rabilirsiniz.<\/p>\n<p><strong>PostgreSQL&#8217;de varchar&#8217;\u0131 Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme:  Performans Analizi ve Edge Case&#8217;ler (\u0130leri Seviye)<\/strong><\/p>\n<p>\u00c7ok b\u00fcy\u00fck bir veri k\u00fcmesiyle \u00e7al\u0131\u015f\u0131yorsan\u0131z, <code class=\"language-\">CASE<\/code> ifadesinin performans\u0131 d\u00fc\u015f\u00fcrebilir.  Bu durumda, daha karma\u015f\u0131k sorgulamalar veya fonksiyonlar kullanman\u0131z gerekebilir.  \u00d6rne\u011fin,  <code class=\"language-\">regexp_matches<\/code> fonksiyonunu kullanarak daha esnek e\u015fle\u015ftirmeler yapabilirsiniz.  Ancak, bu fonksiyonlar daha fazla i\u015flem g\u00fcc\u00fc gerektirebilir.  Performans\u0131 analiz etmek i\u00e7in <code class=\"language-\">EXPLAIN ANALYZE<\/code> komutunu kullanabilirsiniz. Bu komut, sorgunuzun y\u00fcr\u00fct\u00fclme plan\u0131n\u0131 ve her ad\u0131m\u0131n s\u00fcresini g\u00f6sterir.<\/p>\n<p><strong>Edge Case \u00d6rne\u011fi:<\/strong>  <code class=\"language-\">varchar<\/code> s\u00fctununuzda beklenmedik de\u011ferler varsa (\u00f6rne\u011fin, bo\u015fluklar, b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf farkl\u0131l\u0131klar\u0131),  <code class=\"language-\">trim()<\/code> ve <code class=\"language-\">lower()<\/code> fonksiyonlar\u0131n\u0131 kullanarak verileri temizleyebilirsiniz.<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    CASE\n        WHEN lower(trim(status)) = 'true' THEN TRUE\n        WHEN lower(trim(status)) = 'false' THEN FALSE\n        ELSE NULL\n    END AS boolean_status\nFROM my_table;<\/code><\/pre>\n<p>Bu \u00f6rnek, <code class=\"language-\">status<\/code> s\u00fctunundaki de\u011ferleri temizleyerek (bo\u015fluklar\u0131 silerek ve k\u00fc\u00e7\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrerek) daha g\u00fcvenilir bir <code class=\"language-\">boolean<\/code> d\u00f6n\u00fc\u015f\u00fcm\u00fc sa\u011flar.<\/p>\n<p><strong>PostgreSQL&#8217;de varchar&#8217;\u0131 Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme:  Veri Temizli\u011fi ve \u015eema De\u011fi\u015fikli\u011fi<\/strong><\/p>\n<p>Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc ve performans\u0131 optimize etmek i\u00e7in, m\u00fcmk\u00fcnse <code class=\"language-\">varchar<\/code> s\u00fctununu do\u011frudan <code class=\"language-\">boolean<\/code> t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmek en iyi \u00e7\u00f6z\u00fcmd\u00fcr.  Ancak, bunu yapmadan \u00f6nce verilerinizi dikkatlice temizlemeniz ve tutarl\u0131 hale getirmeniz gerekir.  Yanl\u0131\u015f veya beklenmedik de\u011ferleri tespit etmek ve bunlar\u0131 d\u00fczeltmek veya <code class=\"language-\">NULL<\/code> olarak i\u015faretlemek \u00f6nemlidir.  Veri temizli\u011fi i\u015flemi tamamland\u0131ktan sonra, <code class=\"language-\">ALTER TABLE<\/code> komutunu kullanarak s\u00fctun t\u00fcr\u00fcn\u00fc de\u011fi\u015ftirebilirsiniz.  Bu i\u015flem, veritaban\u0131n\u0131z\u0131n boyutuna ba\u011fl\u0131 olarak zaman alabilir, bu y\u00fczden veritaban\u0131n\u0131z\u0131 yedeklemeyi unutmay\u0131n.<\/p>\n<p><strong>PostgreSQL&#8217;de varchar&#8217;\u0131 Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme:  \u00d6zet ve S\u0131k\u00e7a Sorulan Sorular<\/strong><\/p>\n<p>Bu makalede, PostgreSQL&#8217;de <code class=\"language-\">varchar<\/code> t\u00fcr\u00fcndeki verileri <code class=\"language-\">boolean<\/code> t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmenin farkl\u0131 y\u00f6ntemlerini ve performans optimizasyonlar\u0131n\u0131 ele ald\u0131k.  <code class=\"language-\">CASE<\/code> ifadesi basit durumlarda yeterli olurken, b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in daha geli\u015fmi\u015f teknikler kullanman\u0131z gerekebilir.  Veri temizli\u011fi ve tutarl\u0131l\u0131\u011f\u0131, ba\u015far\u0131l\u0131 bir d\u00f6n\u00fc\u015f\u00fcm i\u00e7in \u00e7ok \u00f6nemlidir.  M\u00fcmk\u00fcnse, veritaban\u0131 \u015femas\u0131n\u0131 de\u011fi\u015ftirerek <code class=\"language-\">varchar<\/code> s\u00fctununu do\u011frudan <code class=\"language-\">boolean<\/code> t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmek en iyi performans\u0131 sa\u011flar.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1. <strong><code class=\"language-\">varchar<\/code>&#8216;\u0131 <code class=\"language-\">boolean<\/code>&#8216;a d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in en iyi y\u00f6ntem nedir?<\/strong>  En iyi y\u00f6ntem, veri k\u00fcmesine ve performans gereksinimlerine ba\u011fl\u0131d\u0131r.  K\u00fc\u00e7\u00fck veri k\u00fcmeleri i\u00e7in <code class=\"language-\">CASE<\/code> ifadesi yeterli olabilir, ancak b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in \u015fema de\u011fi\u015fikli\u011fi ve <code class=\"language-\">boolean<\/code> indeksleri daha iyi performans sa\u011flayabilir.<\/p>\n<p>2. <strong><code class=\"language-\">varchar<\/code> s\u00fctununda beklenmedik de\u011ferler varsa ne yapmal\u0131y\u0131m?<\/strong>  Verileri temizlemek ve tutarl\u0131 hale getirmek i\u00e7in <code class=\"language-\">trim()<\/code>, <code class=\"language-\">lower()<\/code>, ve di\u011fer fonksiyonlar\u0131 kullan\u0131n.  Beklenmedik de\u011ferleri <code class=\"language-\">NULL<\/code> olarak i\u015faretleyebilirsiniz.<\/p>\n<p>3. <strong><code class=\"language-\">CASE<\/code> ifadesi performans\u0131 nas\u0131l etkiler?<\/strong>  <code class=\"language-\">CASE<\/code> ifadesi, \u00f6zellikle b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in performans\u0131 d\u00fc\u015f\u00fcrebilir.  Performans\u0131 analiz etmek i\u00e7in <code class=\"language-\">EXPLAIN ANALYZE<\/code> komutunu kullan\u0131n.<\/p>\n<p>4. <strong><code class=\"language-\">varchar<\/code> s\u00fctununu <code class=\"language-\">boolean<\/code> t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmek g\u00fcvenli midir?<\/strong>  Verileri temizledikten ve tutarl\u0131 hale getirdikten sonra g\u00fcvenlidir.  Ancak, veritaban\u0131n\u0131z\u0131 yedeklemeyi unutmay\u0131n.<\/p>\n<p>5.  <strong>PostgreSQL&#8217;de Boolean de\u011ferlerini nas\u0131l daha etkili bir \u015fekilde y\u00f6netebilirim?<\/strong>  Daha detayl\u0131 bilgi i\u00e7in [fatihsoysal.com](https:\/\/fatihsoysal.com) adresini ziyaret edebilirsiniz. (Bu k\u0131s\u0131m \u00f6rnek bir ba\u011flant\u0131d\u0131r, isterseniz farkl\u0131 bir ba\u011flant\u0131 ekleyebilirsiniz veya kald\u0131rabilirsiniz.)<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de varchar&#8217;\u0131 Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme: Tam Bir K\u0131lavuz PostgreSQL veritaban\u0131n\u0131zda metin t\u00fcr\u00fcnde (varchar) saklanan &#8220;evet\/hay\u0131r&#8221;, &#8220;do\u011fru\/yanl\u0131\u015f&#8221; gibi Boolean&hellip;","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":[644],"tags":[],"class_list":{"0":"post-25642","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-postgresql","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>PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean&#039;a D\u00f6n\u00fc\u015ft\u00fcrme<\/title>\n<meta name=\"description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\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\/postgresql-varchar-turunu-booleana-donusturme\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean&#039;a D\u00f6n\u00fc\u015ft\u00fcrme\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-10T06:15:23+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=\"6 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme\",\"datePublished\":\"2025-07-10T06:15:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/\"},\"wordCount\":1097,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/\",\"name\":\"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean'a D\u00f6n\u00fc\u015ft\u00fcrme\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-07-10T06:15:23+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme\"}]},{\"@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":"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean'a D\u00f6n\u00fc\u015ft\u00fcrme","description":"Hi\u00e7bir etiketi bulunamad\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\/postgresql-varchar-turunu-booleana-donusturme\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean'a D\u00f6n\u00fc\u015ft\u00fcrme","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-07-10T06:15:23+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme","datePublished":"2025-07-10T06:15:23+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/"},"wordCount":1097,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["PostgreSQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/","name":"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean'a D\u00f6n\u00fc\u015ft\u00fcrme","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-07-10T06:15:23+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-varchar-turunu-booleana-donusturme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: varchar T\u00fcr\u00fcn\u00fc Boolean&#8217;a D\u00f6n\u00fc\u015ft\u00fcrme"}]},{"@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\/25642","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=25642"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/25642\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=25642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=25642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=25642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}