*iso-8859-9, yazim hatasi yapmisim.<br /><br />16:35, 11 Nisan 2017, Samed YILDIRIM <samed(at)reddoc(dot)net>:<br /><blockquote>Merhabalar,<div><br /></div><div>Dosyayi actiginiz metin editorunun utf8 uyumlu oldugundan emin misiniz? UTF8 metni iso-8859-1 (windows-1254) kodlamasi ile acmissiniz gibi gorunuyor.</div><div><br /></div><div>İyi calismalar.<br /><br />16:17, 11 Nisan 2017, Ahmet Gunata <<a href="mailto:ahmet(dot)gunata(at)bimsa(dot)com">ahmet(dot)gunata(at)bimsa(dot)com</a>>:<br /><blockquote><br /><br /><br /><br /><br /><br /><div lang="TR" link="#0563C1" vlink="#954F72"><br /><div><br /><p>Merhaba,</p><br /><p> </p><br /><p>utf-8 yapıdaki veritabanında yer alan bir tablodan COPY komutu ile bir CSV dosyası üretmek istediğim zaman Türkçe karakterlerin doğru çıkarılamadığını görüyorum.</p><br /><p> </p><br /><p><span style="font-family:"Courier New";">B2C_DBase=# select version();</span></p><br /><p><span style="font-family:"Courier New";"> version <br /></span></p><br /><p><span style="font-family:"Courier New";">--------------------------------------------------------------------------------------------------------------</span></p><br /><p><span style="font-family:"Courier New";">PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.<span><span>7 20120313</span></span> (Red Hat 4.4.7-4), 64-bit</span></p><br /><p><span style="font-family:"Courier New";">(1 row)</span></p><br /><p><span style="font-family:"Courier New";"> </span></p><br /><p><span style="font-family:"Courier New";">B2C_DBase=# SHOW LC_CTYPE;</span></p><br /><p><span style="font-family:"Courier New";"> lc_ctype </span></p><br /><p><span style="font-family:"Courier New";">-------------</span></p><br /><p><span style="font-family:"Courier New";">en_US.utf-8</span></p><br /><p><span style="font-family:"Courier New";">(1 row)</span></p><br /><p><span style="font-family:"Courier New";"> </span></p><br /><p><span style="font-family:"Courier New";">B2C_DBase=# \l</span></p><br /><p><span style="font-family:"Courier New";"> <br /></span></p><br /><p><span style="font-family:"Courier New";"> List of databases</span></p><br /><p><span style="font-family:"Courier New";"> Name | Owner | Encoding | Collate | Ctype | Access privileges <br /></span></p><br /><p><span style="font-family:"Courier New";">------------+----------+----------+-------------+-------------+--------------------------------</span></p><br /><p><span style="font-family:"Courier New";">……</span></p><br /><p><span style="font-family:"Courier New";">B2C_DBase | postgres | UTF8 | en_US.utf-8 | en_US.utf-8 | =Tc/postgres +</span></p><br /><p><span style="font-family:"Courier New";"> | | | | | postgres=CTc/postgres +</span></p><br /><p><span style="font-family:"Courier New";"> | | | | | xxxxxxxxxx=c/postgres +</span></p><br /><p><span style="font-family:"Courier New";"> | | | | | xxxxxxxxxx=c/postgres</span></p><br /><p><span style="font-family:"Courier New";">……….</span></p><br /><p><span style="font-family:"Courier New";">(9 rows)</span></p><br /><p><span style="font-family:"Courier New";"> </span></p><br /><p><span style="font-family:"Courier New";">B2C_DBase=# SHOW client_encoding;</span></p><br /><p><span style="font-family:"Courier New";">client_encoding <br /></span></p><br /><p><span style="font-family:"Courier New";">-----------------</span></p><br /><p><span style="font-family:"Courier New";">UTF8</span></p><br /><p><span style="font-family:"Courier New";">(1 row)</span></p><br /><p><span style="font-family:"Courier New";"> </span></p><br /><p><span style="font-family:"Courier New";">B2C_DBase=# COPY exportme to '/tmp/exportme.csv' delimiters',' CSV HEADER;</span></p><br /><p><span style="font-family:"Courier New";">COPY 376883</span></p><br /><p><span style="font-family:"Courier New";">B2C_DBase=#</span></p><br /><p> </p><br /><p> </p><br /><p>Dosya çıktısından bir kısım;</p><br /><p> </p><br /><p>81214 ,bakım%50,bakımyüzde50,bakımyüzde50,8martindirim,ciltbakım15,bakimyuzde50,bakimkampanyali15</p><br /><p> </p><br /><p> </p><br /><p>Bu konuda nasıl bir yol izlenmesi gerektiğini paylaşabilir misiniz?</p><br /><p> </p><br /><p>Teşekkürler,</p><br /><p>Ahmet GÜNATA</p><br /></div><br /><br /><br /><hr /><br /><font face="Verdana" color="Gray" size="1"><br /><br />This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited.<br /> Anyone who receives this message in error should notify the sender immediately by telephone or by return communication and delete it from his or her computer.<br /><br /><br /><br />Bu ileti hukuken korunmuş, gizli veya ifşa edilmemesi gereken bilgiler içerebilir. Şayet mesajın gönderildiği kişi değilseniz, bu iletiyi çoğaltmak ve dağıtmak yasaktır. Bu mesajı yanlışlıkla alan kişi, bu durumu derhal gönderene telefonla ya da e-posta ile<br /> bildirmeli ve bilgisayarından silmelidir.<br /><br /></font><br /></div><br /><br /></blockquote></div>
<br /></blockquote>