ntw Posted January 11, 2007 Report Share Posted January 11, 2007 WTFx8 `apraksts` longtext character set utf8 collate utf8_bin NOT NULL, <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> īstenīb�? ....tur vajadzētu būt rakstītam "īstenībā"... Lieta ir tāda, ka VISAS garumzīmes strādā IZŅEMOT "Ā" ....WTF-8 :D ....? Link to comment Share on other sites More sharing options...
andrisp Posted January 11, 2007 Report Share Posted January 11, 2007 (edited) No dažādiem mysql klientiem mēģināji un visur viens rezultāts? Edited January 11, 2007 by andrisp Link to comment Share on other sites More sharing options...
ntw Posted January 11, 2007 Author Report Share Posted January 11, 2007 emm...nē... Link to comment Share on other sites More sharing options...
andrisp Posted January 11, 2007 Report Share Posted January 11, 2007 Tas ir - nemēģināji, vai arī mēģināji un uz citiem klientiem ok bija ? Link to comment Share on other sites More sharing options...
bubu Posted January 11, 2007 Report Share Posted January 11, 2007 Vēl jau variants - nevis velkot datus ārā no db un rādot htmlu rodas nepareizs burts, bet gan ievietojot jau sačakarējas teksts! Stulbs jautājums - vai tu zini, kas ir SET NAMES utf-8 ? Link to comment Share on other sites More sharing options...
ntw Posted January 11, 2007 Author Report Share Posted January 11, 2007 Hmm...acīmredzot vēl nezinu, ... SET neims man būtu jāpievieno kur...? Link to comment Share on other sites More sharing options...
andrisp Posted January 11, 2007 Report Share Posted January 11, 2007 Skriptā uzreiz pēc tam, kad atver konekciju ar mysql serveri. mysql_query("SET NAMES utf-8"); Tādā veidā klients ar serveri norunā, ka nu tagad runās utf8'iski. Link to comment Share on other sites More sharing options...
ntw Posted January 11, 2007 Author Report Share Posted January 11, 2007 provēšu... Link to comment Share on other sites More sharing options...
bubu Posted January 11, 2007 Report Share Posted January 11, 2007 Njā.. kārtējo reizi simtu reižu jau pārrunāta, regulāri gandrīz katru mēnesi cilāta kļūda. Link to comment Share on other sites More sharing options...
ntw Posted January 11, 2007 Author Report Share Posted January 11, 2007 Nope. Tas pats. SET NAMES arī nepalīdz, jautājums zīmes ir tikuntā... Hmm...Man pēc idejas ir nekonfigurēts kkādas pakas MySQL lokālajam testingam. Mby uzlādēt uz hosta un apskatīt, vai tur tāpat notiekās? Rezultāts varētu būt savādāks? Link to comment Share on other sites More sharing options...
bubu Posted January 11, 2007 Report Share Posted January 11, 2007 Pie datu ievietošanas arī uzlikti to SET NAMES? Jo, ja jau dati ievietoti šķībi, tad pie izvilkšanas nekāds SET NAMES nepalīdzēs. Link to comment Share on other sites More sharing options...
ntw Posted January 12, 2007 Author Report Share Posted January 12, 2007 mysql_connect($dbhost, $dbuser, $dbpass) or die("Kljuuda konektaa <br />") . mysql_error(); mysql_select_db($db) or die("Kljuuda ar DB <br />") . mysql_error(); mysql_query("SET NAMES utf-8"); Link to comment Share on other sites More sharing options...
Grey_Wolf Posted January 12, 2007 Report Share Posted January 12, 2007 DB versija? + SETNAMES... vajadzeetu paliidzeet, jo ja pie vainas ir tieshi sii probleema tad parasti pazuud Ā un Š uzraksti visus lielos un mazos burtus kam ir garumziimes un miikstinajuma ziimes un paskaties kurus raada nepareizi.... + velreiz parliecinies ka VISUR tiek izmantots tas SETNAME..... dazreiz gadaas ka itkaa tiek pielikts, bet kautkur tomeer aizmirstas... taadeelj iesaku izmantot atseviskju Includojamu failu ar galvenajaam saitaa izmantotaajaam f-jaam (DB conekteeshanai, teksta atiiriisanai no nevelamiem simboliem testeeshanas f-jaam utt) tad vareesi buut 99,99% droshh ka visur tiks izmantots viens un tas pats... ------- Link to comment Share on other sites More sharing options...
Joyride Posted January 12, 2007 Report Share Posted January 12, 2007 He he, man ar' šāda problēma bija. Risinājums - pamaini iekš tabulas "collation" (pieņemu, ka stāv uz utf8_general_ci), paprovē uz latin1_swedish_ci kaut ko tādu, no galvas grūti atcerēties. Link to comment Share on other sites More sharing options...
andrisp Posted January 12, 2007 Report Share Posted January 12, 2007 collation par to neatbild, cik zinu. Link to comment Share on other sites More sharing options...
Recommended Posts