Results 1 to 15 of 15

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341

    Importing db

    - , , . 2 utf8_general_ci. - ?

    !
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

  2. #2
    philosophus duratea icaci's Avatar
    Join Date: Oct:2006
    Location: Aachen
    Posts: 2,698
    utf8_general_ci ( , , "" "", "" ""), . SET NAMES `utf8` .
    Internet - it doesn't make you stupid, it just makes your stupidity more accessible to others

  3. #3
    Registered User
    Join Date: Nov:2005
    Location:
    Posts: 3,317
    . .

  4. #4
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    .
    utf-8, .

  5. #5
    TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341
    , . !

    () .. _ utf-8, utf-8 , - .
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

  6. #6
    Registered User
    Join Date: Nov:2005
    Location:
    Posts: 3,317
    , , , .? ?

  7. #7
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    .sql ( )
    Code:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

    Code:
    /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    .

    , utf8 !

  8. #8
    TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341
    .sql :
    Code:
    "/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    -- phpMyAdmin SQL Dump
    -- version 2.9.1.1
    -- http://www.phpmyadmin.net
    -- 
    -- Host: localhost
    -- Generation Time: Jul 26, 2008 at 
    
    10:36 AM
    -- Server version: 5.0.27
    -- PHP Version: 5.2.0"
    , tedych :

    Code:
    "......  _    ', '', 'images/3_Write/1_Pen/1_3_OneDay/4110.jpg', 
    
    NULL);
    
    /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;"
    Encoding- .sql UTF-8. :

    Code:
    "
            SQL .   -,     .        ,           .                MySQL.    MySQL  -,   ,         .                  ,    SQL     ,           CUT  -:
    ----BEGIN CUT----
    eNptzd1KwzAAxfH7PMURdjXaNInJPgJCQw3bIGtrUudlcThmoda6oc5n24WP5CvYee3tn8P5We8L
    r5FxZALO5hocApMpCdWQz4Rkm6AxWj1pHN/a/vFw3B1o22xp/9xHHxB0QgWVEIzJhF0nTIHPtBJa
    SbS7lznsqceIrL/CndOQlFMh4vZ1T+6DRxEimIXNqwgbO2gPTYeitN5gThUj5droAVB0GvctJ+Wy
    vMyiIlyOJJ3BNd37iTiTLzS2+/iz6bhQnPxRP+fvZHwlGWccwVZIC3dbZ0vjTVZZXw+pztxqsG/S
    9L+McfILXSpKjw==
    ----END CUT----
    ----BEGIN RAW----
    ERROR: C1 C2 LEN: 1 2 67
    STR: 
    
    CVS: $Id: sqlparser.lib.php,v 2.6.2.4 2004/03/05 18:52:54 lem9 Exp $
    MySQL: 4.1.22-log
    USR OS, AGENT, VER: Win OPERA 9.50
    PMA: 2.5.7-pl1
    PHP VER,OS: 4.4.8 Linux
    LANG: bg-win1251
    SQL: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
    ----END RAW----
    
    SQL- :  
    
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */ 
    
    MySQL : 
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1"
    ?

    - SQL host.bg?






    SQL compatibility mode MYSQL40 MYSQL323, . ( Save as File) ANSI encoding , - , , .. , . ,
    Code:
    CREATE TABLE tablename_cyrilic (`field` ....

    Code:
    'e_cyrilic (`field` ....
    ? - ( 187), .
    Last edited by TEKIL4O; 31st July 2008 at 18:24.
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

  9. #9
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , , . .

    BOM urf8 , . , 3 BOM-a.

    sql-a , mysql 4.x.
    phpmyadmin, - 3306, mysql Administrator (), / , , .
    . ? CPanel IP , .

  10. #10
    TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341
    ! "" sql-a , "" . _ - ""-
    Code:
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` (
      `id` int(20) NOT NULL auto_increment,
      `num` varchar(500) default NULL' at line 1
    ""-? ?
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

  11. #11
    TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341
    Quote Originally Posted by TEKIL4O View Post
    ! "" sql-a , "" . _ - ""-
    Code:
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` (
      `id` int(20) NOT NULL auto_increment,
      `num` varchar(500) default NULL' at line 1
    ""-? ?

    . 11 "" . , . , , ( , ) - 1 ;(, . tedych!!!

    PHP 4.4.8 PHP 5.2.0
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

  12. #12
    TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341
    ..
    , . Scintilla - phpmyadmin , utf8( utf8 with BOM utf8). Notepad ANSI - 55 :
    Code:
    
    SQL- :  
    
    CREATE TABLE `_` (
    `id` int( 20 ) NOT NULL AUTO_INCREMENT ,
    `num` varchar( 500 ) default NULL ,
    `name` varchar( 1000 ) default NULL ,
    `desc` varchar( 10000 ) default NULL ,
    `price` varchar( 500 ) default NULL ,
    `pic` varchar( 5000 ) default NULL ,
    `img` longblob,
    PRIMARY KEY ( `id` ) 
    ) TYPE = MYISAM AUTO_INCREMENT =13 
    
    
    MySQL : 
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` (
      `id` int(20) NOT NULL auto_increment,
      `num` varchar(500) default NULL' at line 1
    1-2 ...
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

  13. #13
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    , . ' ...
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  14. #14
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , ,
    '' 2-3 .. , , ...

    Edit:
    ''-. :
    Code:
    `kind` SET('','','','','','','','','') NOT NULL,
    , ,

    , , PHP 4.x. . . .
    php5. , , . , , .
    Last edited by tedych; 1st August 2008 at 17:51.

  15. #15
    TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341
    PHP-. 15. .htaccess PHP5 6. SQL- , , . , ( ).

    "" , ... , . -

    !
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |