archeeens Posted February 24, 2009 Report Share Posted February 24, 2009 Sveiki pārgāju no V6 uz V7 php-fusion versiju un tagad man ir problēma ar datubāzi. V7 neatpazīst pareizi saturu. Kā salabot saturu, lai heroglifu vietā būtu normālas garumzīmes, jo uz v7 jauno saturu datubāzēs viņš glabā ar normālām garumzīmēm. skatīt attēlā. Ar cieņu, Artis Quote Link to comment Share on other sites More sharing options...
Klez Posted February 24, 2009 Report Share Posted February 24, 2009 pameklē forumā atslēgvārdi: utf-8 "set names" Quote Link to comment Share on other sites More sharing options...
archeeens Posted February 24, 2009 Author Report Share Posted February 24, 2009 nelīdz nekā no tiem set utf-8 Quote Link to comment Share on other sites More sharing options...
cucumber Posted February 24, 2009 Report Share Posted February 24, 2009 mosh Collation, kur vaina? Vari uzrakstit sciprtu, kas izsauc visus ierakstus sakuma "set names utf8" pieprasijumu un parrakstit vinus datubaze, 4z risinajums, bet it ka vajadzetu nostradat Quote Link to comment Share on other sites More sharing options...
archeeens Posted February 24, 2009 Author Report Share Posted February 24, 2009 nelīdz. Varbūt ir kāds konverteris, kurš pataisa saturu normālās garumzīmēs? Quote Link to comment Share on other sites More sharing options...
cucumber Posted February 24, 2009 Report Share Posted February 24, 2009 (edited) intersanti? ja tu pasha parluka uzliec citu kodejumu, rada pareizi vai ne? bishcinj ne pa temu, bet mosh shis lidzes http://rishida.net/scripts/uniview/conversion.php Edited February 24, 2009 by cucumber Quote Link to comment Share on other sites More sharing options...
archeeens Posted February 24, 2009 Author Report Share Posted February 24, 2009 Lūk http://test.wc3.lv pārgāju uz v& no v6 un viss saturs pa pipeli. arī mysql_query("set names latin1") ; nelīdz. Quote Link to comment Share on other sites More sharing options...
Klez Posted February 24, 2009 Report Share Posted February 24, 2009 tu esi saputrojies ar kodingiem un enkodingiem ... kaads failiem enkoding ... un vispaar mekleeshanu vajag izmantot. paskaties arhiivaa. shii teema ir apspriesta n reizes .. Quote Link to comment Share on other sites More sharing options...
archeeens Posted February 25, 2009 Author Report Share Posted February 25, 2009 da tur kkas nesaprotams, visādi veidi izmēģināti bet nekā ;/ Varbūt vienkārši ir kāds veids pārvērst esošo saturu datubāzē normālu ar garumzīmēm ar kādiem palīgrīkiem vai konvertoriem? Quote Link to comment Share on other sites More sharing options...
cucumber Posted February 25, 2009 Report Share Posted February 25, 2009 iemet dumpu Quote Link to comment Share on other sites More sharing options...
archeeens Posted February 26, 2009 Author Report Share Posted February 26, 2009 iemet dumpu Jā noteikti tā es te metīšu dumpu visiem ar 5000+ lietotājiem:D Reāli ir kāds risinājums? Quote Link to comment Share on other sites More sharing options...
Aleksejs Posted February 26, 2009 Report Share Posted February 26, 2009 Kaut kādas baisi līdzīgas jums tās tabulas ;) Ar šī posta autoru: http://php.lv/f/index.php?showtopic=12194&hl=iconv* Manuprāt arī risinājums tur izskanēja. Quote Link to comment Share on other sites More sharing options...
archeeens Posted February 26, 2009 Author Report Share Posted February 26, 2009 Kaut kādas baisi līdzīgas jums tās tabulas ;)Ar šī posta autoru: http://php.lv/f/index.php?showtopic=12194&hl=iconv* Manuprāt arī risinājums tur izskanēja. No tiem ieteikumiem nekas nelīdzēja. Piedodiet biju piemirsi ka te jau biju ierakstījis rakstu. Bet reāli jau mocos 2 mēnešus ar šo problēmu. Quote Link to comment Share on other sites More sharing options...
Aleksejs Posted February 26, 2009 Report Share Posted February 26, 2009 Pamēģini tad tīri eksperimenta dēļ: mysql_query("SET NAMES utf8", $db_connect); mysql_query( "SET CHARACTER SET utf8", $db_connect ); Tad izselektē kādu lauku: Un izveic viņam: $lauks = iconv("ISO-8859-1", "UTF-8", "This is a test."); Un noupdato konkrēto DB ierakstu ar INSERT INTO, norādot kā jauno vērtību $lauks Quote Link to comment Share on other sites More sharing options...
archeeens Posted February 26, 2009 Author Report Share Posted February 26, 2009 Problēma bija garmtech hostā ar import, tagad viss ok. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.