spynode Posted September 20, 2005 Report Share Posted September 20, 2005 (edited) Maajaas es veidoju lapu izmantojot 4.x versijas MySQL datubaazi, bet ieliekot serverii un uzmetot mysql_get_server_info(); es skaots, ka versija ir 3.23.58. Man SQL sinatksee piesienaas katram vaardam. piemeeram You have an error in your SQL syntax near 'DEFAULT CHARSET=cp1257; CREATE TABLE `articles` ( `id` int(10) unsigned ' at line 7 7. liinija : DEFAULT CHARSET=cp1257; Ko man dariit ? Kaa shaadas probleems tiek noveerstats ? Tas vispaar ir normaali, ka uz publiskaa hostinga servera stav tik aizveesturisks MySQL ? Edited September 20, 2005 by spynode Link to comment Share on other sites More sharing options...
Delfins Posted September 20, 2005 Report Share Posted September 20, 2005 Izdari loģisko secinājumu. Link to comment Share on other sites More sharing options...
spynode Posted September 20, 2005 Author Report Share Posted September 20, 2005 Izdari loģisko secinājumu. 22639[/snapback] Nu paldies par sakariigo atbildi. Varbuut kaads spees arii paliidzeet ... Kaa tad 3.x versijaas noraadaas tabulas kodeejums ? Link to comment Share on other sites More sharing options...
Delfins Posted September 20, 2005 Report Share Posted September 20, 2005 Par tādu lietu kā `Dokumentācija` esi dzirdējis? Link to comment Share on other sites More sharing options...
spynode Posted September 20, 2005 Author Report Share Posted September 20, 2005 (edited) Par tādu lietu kā `Dokumentācija` esi dzirdējis? 22642[/snapback] Esmu, bet tur ir UPGRADE from 3.23 to 4.0 nodalja, par sintakses izmainjaam utt, bet nav taadas lietas kaa downgrade (duh). Nav arii manuaalja 3.x versijaam. Tad ko iisti tu man ar to gribeeji ieteikt ? Kaads zinoshaaks cilveeks ir ? Es zinu, ka nekas buutiski nav jaaizmaina, bet esmu vienmeer lietojis izgliitojoties MySQL 4.x versijas, taadeelj 3.x man ir melna bilde. Edited September 20, 2005 by spynode Link to comment Share on other sites More sharing options...
Grey_Wolf Posted September 20, 2005 Report Share Posted September 20, 2005 3.23 netabalsta ------ DEFAULT CHARSET=cp1257; ------- man skjiet ka to sak atbalstiit tikai 4.1 pat 4.0 versija nevar katrai tabulai pieskjirt citu kodeejumu tikai visai DB kopumaa -------- tas arii viss Link to comment Share on other sites More sharing options...
Kristabs Posted September 20, 2005 Report Share Posted September 20, 2005 vienkaarshi no .sql izdzees visas to default charset vietas un baro veelreiz. Link to comment Share on other sites More sharing options...
Delfins Posted September 20, 2005 Report Share Posted September 20, 2005 (edited) spynode, es mēģinu saprast, kāpēc ir jāpaliek pie 3.x, ja ir 4.0 ? 4.1 laikam neiesaku lietot.. Edited September 20, 2005 by Delfins Link to comment Share on other sites More sharing options...
bubu Posted September 20, 2005 Report Share Posted September 20, 2005 4.1 laikam neiesaku lietot..22648[/snapback] Kāpēc? Link to comment Share on other sites More sharing options...
Delfins Posted September 20, 2005 Report Share Posted September 20, 2005 es teicu `laikam` Lietoju 4.0.x.. un neredzu jēgas pāriet uz 4.1.x/5.x Link to comment Share on other sites More sharing options...
bubu Posted September 20, 2005 Report Share Posted September 20, 2005 Nu kautvai UTF-8? Neskaitot vairāku citus sīkumus - jaunas fjas, utt Link to comment Share on other sites More sharing options...
Grey_Wolf Posted September 20, 2005 Report Share Posted September 20, 2005 spynode, es mēģinu saprast, kāpēc ir jāpaliek pie 3.x, ja ir 4.0 ?4.1 laikam neiesaku lietot.. 22648[/snapback] ta spriezot pec shii DEFAULT CHARSET=cp1257 vinsh jau lieto 4.1 :) 4.0 sho nesaportee :) P.S. maajas vnjam iet - taatad vers >=4.1. Link to comment Share on other sites More sharing options...
Delfins Posted September 20, 2005 Report Share Posted September 20, 2005 Nu kautvai UTF-8? Neskaitot vairāku citus sīkumus - jaunas fjas, utt 22658[/snapback] lieku mysql 4.0 tabulās tikai UTF datus... man nav prob... Em... vot kad mysql būs kas līdzīgs pgsql, tad i domāšu par pāriešanu :) Standarta webs, kur pamatā ir cipariņi un uzskaite, neko vairāk par SELECT,GROUP,COUNT nevajag :) Tā teikt, blogam taču neizmantosi oracle_10g klāsterī :) Link to comment Share on other sites More sharing options...
Recommended Posts