intero

paldies par "lielo atsaucību"! lai nu kā - konstatēju, ka veicot INSERT INTO datubāzē, dati pie SELECTa atgriežas pareizi. Šādā veidā viss sanāk. Tomēr, šāda postojot datus mums visiem labi zināmai riks phpMyAdmin atgriež ievadītos datu neapotamos sīmbolos. ir kādi ieteikumu sakarā ar phpMyAdmin?

kā lai to noskaidro?

jau ieprieksh Dumpu raxtiiju. CREATE DATABASE `test` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; CREATE TABLE `aaa` ( `name` VARCHAR( 255 ) NOT NULL , `text` VARCHAR( 255 ) NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin;

nepalīdz.

Sveiki! Šī tēma ir aprakstīta krustām šķērsām, tomēr problēmas risinājumu es neesmu atradis. OS kur problēma novērota: Ubuntu. Apache2: AddDefaultCharset UTF-8 AddCharset UTF-8 .utf8 MySQL5: Server variables and settings ..... character set client utf8 (Global value) latin1 character set connection utf8 (Global value) latin1 character set database latin1 character set filesystem binary character set results utf8 (Global value) latin1 character set server latin1 character set system utf8 character sets dir /usr/share/mysql/charsets/ collation connection utf8_bin (Global value) latin1_swedish_ci collation database latin1_swedish_ci collation server latin1_swedish_ci ........ Problēma sekojoša: index.php kods(kodēts utf-8) <? $user = 'root'; $passwd = '0000'; $hostname = 'localhost'; $d_base = 'test'; mysql_connect ($hostname,$user,$passwd) or die('Nevar pieslēgties serverim'); mysql_select_db ($d_base) or die ('Nevar pieslēgties datubāzie'); ?> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <? $sql = mysql_query('SELECT * FROM aaa'); if($sql){ while ($s = mysql_fetch_array($sql)) { echo $ 600 ;s[0] . ' > '. $s[1] .'<br>'; } } else { echo 'wtf '; } echo 'šņāceņi'; ?> MySQL DUMPS -- -- Database: `test` -- -- -------------------------------------------------------- -- -- Table structure for table `aaa` -- CREATE TABLE `aaa` ( `name` varchar(255) collate utf8_bin NOT NULL, `text` varchar(255) collate utf8_bin NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `aaa` -- INSERT INTO `aaa` VALUES (0xc4bcc5a1c5a1c586c5a1c586c4b7c481c5be, 0xc5a1c4a3c481c481c481c493c5be); INSERT INTO `aaa` VALUES (0xc4bcc4b7c4bcc5bec4b7c4b7c5a1c5a1c481c586, 0x6473646664c5a166c5a1647366c5a1); Problēma izpaužās, ka web lapa atspoguļo sekojošo: ?��?�???� > �?????� ???�??��?? > dsdfd�f�dsf� šņāceņi Kādi komentāri? P.S. man nepatīk tas Latin1 Gobālajos Values.

Novilku un uzliku MYSQL Source viss uzlikās loti smuki ... Liku PHP un tagad nokompilējās, tomēr bez rezultātiem. :( uztaisu php ar Select no mysql tomeer liidz selectam netiek :P Fatal error: Call to undefined function mysql_connect() in /usr/local/apache2/htdocs/test/index.php on line 8

nu bet man nav vajadziigs mysql 5 source.. Man ir vajadziigas mysql libi: mysql-devel, mysql-shared un mysql-client .... mysql man jau ir uzlikts un tiiri labi straadaa :) tikai PHP nekompileejaas un met aaraaa checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no

kur lai taaas pakas izrauj ??? visuur ir pilns ar tiem RPM prieksh redhat, bet source un tgz pakas nav. varbuut es kaut ko nesaprotu ... :) PS. es saprotu ka Slackware 10.2 jau saaak palikt par veesturi, bet ko lai dara ?

1. gribeetu atvainoties par dusmu uzpluudumu, un sliktiem izteicieniem :) jo nepamatoti pazuud mans posts 3. paldies ka vispaar kaut ko esat uzraxtiijushi. /usr/local/mysql man ir MYSQL 5 ;) # ps -ef mysql 7209 7191 0 Apr27 ? 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file mysql 7210 7209 0 Apr27 ? 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file mysql 7211 7210 0 Apr27 ? 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file ...........

# ps -ef mysql 7209 7191 0 Apr27 ? 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file mysql 7210 7209 0 Apr27 ? 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file mysql 7211 7210 0 Apr27 ? 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file ........... >>> Ar --with-mysql=/usr #./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql-dir=/usr/local/mysql --with-mysql=/usr --with-zlib-dir=/usr ..... checking for MySQL support... yes checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... no configure: error: Cannot find MySQL header files under /usr. Note that the MySQL client library is not bundled anymore! >>> Ar --with-mysql=/usr/local/mysql #./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql-dir=/usr/local/mysql --with-mysql=/usr/local/mysql --with-zlib-dir=/usr ..... checking for MySQL support... yes checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... no checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no configure: error: mysql configure failed. Please check config.log for more information.

Es jau uzraxtiiju kaa es komileeju, bet shajaa forumaa admini vienkaarshi RULLEE... Vini visu izdzeesh :D Logiski ka neuzbildo ... moduli... bet kas truuxt kompileejot ? Standarta kompilaacija ir ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/usr/local/mysql

Nejeedziigs jautaajums ??? Vienkaarshi te neviens nezin atbildi .. Un taadeel izdzeesh postu. Shajaa Forumaa viss balstiits uz nolaadeetaa Win. es jautaaju par mysql.so moduli ! Peec instalaacijas taa vienkaarshi nav ..

Kaadeel administraacija izdzeesh Postus ???? par PHP 5 instalaaciju ?

Vai kaads var paliidzeet ????? :(

Kaa nevajadzeeja ???? Man shkiet ka vajag, bet kaadeel vina nav ? php.ini ie jaapieliek extension = mysql.so