Dziękuję wszystkim za odpowiedĽ jednakżę nie pomogło teraz zamiast polskich znakow mam znaki zapytania w bazie w kolumnach lastname_ok itd. :/<br>Dodam tylko ze ostatnio zmienilem w lms.ini chyba set names utf8 czy jakos tak bo mialem problemy w panelu lmsa w wyswietlaniu polskich znakow przy nazwiskach w karcie klienta. Cala baza wyglada jakby byla w utf8 collation tez na utf8polish_ci jest ustawione tak więc juz sam niewiem oto fragment kodu z 
lms.class<br><br><br>return $this-&gt;DB-&gt;Execute(&#39;UPDATE customers SET status=?, phone1=?, phone2=?, phone3=?, address=?, zip=?, city=?, email=?, im=?, ten=?, ssn=?, moddate=?NOW?, modid=?, info=?, serviceaddr=?, lastname=UPPER(?), name=?, lastname_ok=?, name_ok=?, deleted=0, message=?, pin=? WHERE id=?&#39;, 
<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; array( $customerdata[&#39;status&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;phone1&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;phone2&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;phone3&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;address&#39;], 
<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;zip&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;city&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;email&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;im&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;ten&#39;], 
<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;ssn&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; isset($this-&gt;AUTH-&gt;id) ? $this-&gt;AUTH-&gt;id : 0,<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;info&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;serviceaddr&#39;], 
<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;lastname&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ucwords($customerdata[&#39;name&#39;]), <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; iconv(&#39;UTF-8&#39;,&#39;ASCII//TRANSLIT&#39;, $customerdata[&#39;lastname&#39;]),<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; iconv(&#39;UTF-8&#39;,&#39;ASCII//TRANSLIT&#39;, uswords($customerdata[&#39;name&#39;])),<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;message&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;pin&#39;], <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $customerdata[&#39;id&#39;]
<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ));<br><br>probowalem rowniez uzyc tej regulki z netdevmap ale ten sam efekt znaki zapytania w polach ://<br><br>Moze kto¶ da rade to rozgryĽć ??<br><br>A może nie mam bazy w utfie8 ale jak to mozliwe zeby to chodzilo skoro wszedzie jest poustawiane na utf8.??
<br><br>Pozdrawiam<br>Michał<br>aha lms 1.8.11 mysql 5.0.24 php5<br><br><div><span class="gmail_quote">25-08-07, <b class="gmail_sendername">A.L.E.C</b> &lt;<a href="mailto:alec@alec.pl">alec@alec.pl</a>&gt; napisał(a):</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Michał Gacek wrote:<br>&gt; Witam mam taki problem potrzebuje aby lastname i name z tabeli customers
<br>&gt; byly kowertowane np do lastname_ok i name_ok ale bez polskich znakow czyli ł<br>&gt; do l itd<br>&gt; Potrzebuje wyeksportowac dane do programu ktory nie obsluguje polskich<br>&gt; znaków. znalazlaem gdzies na necie skrypt w php ale on zamienia z iso. Moja
<br>&gt; baza jest w utf8 przynajmniej tak to wyglada. Wystarczylaby mi funkcja na<br>&gt; sama zamiane sam sobie zaimplentuje aby wstawial wynik w odpowiednie tabele.<br>&gt; Niestety zwyklym strin_replace ł -&gt; l tego nie idzie zrobic bo ł w utfie ma
<br>&gt; wicej niz jeden bajt.<br><br>w LMSie jest taki fragment, w modules/netdevmap.php linie 33-45<br><br>w postgresie można np. tak:<br><br>SELECT to_ascii(convert(lastname || &#39; &#39; || name using<br>utf8_to_iso_8859_2),&#39;LATIN2&#39;)
<br>FROM customers<br><br>--<br>Aleksander &#39;A.L.E.C&#39; Machniak <a href="http://alec.pl">http://alec.pl</a> gg:2275252<br>LAN Management System Developer <a href="http://lms.alec.pl">http://lms.alec.pl</a><br><br>_______________________________________________
<br>lms mailing list<br><a href="mailto:lms@lists.lms.org.pl">lms@lists.lms.org.pl</a><br><a href="http://lists.lms.org.pl/mailman/listinfo/lms">http://lists.lms.org.pl/mailman/listinfo/lms</a><br></blockquote></div><br>