Search found 77 matches: chinese

Searched query: +chinese

Return to advanced search

I want to help translating the XAMPP_FORBIDDEN.html.var file

I see there is a file called XAMPP_FORBIDDEN.html.var in apache and contains some translation, but doesn't contain the language in my country(Chinese).
I'd like to contribute translation for it but I don't know how to do that.
I have contributed many translations to the https://translate.apachefriends.org/ website, but I didn't find this file in that website.
by pop-corner
04. July 2018 10:20
 
Forum: Apache
Topic: I want to help translating the XAMPP_FORBIDDEN.html.var file
Replies: 1
Views: 2205

Re: Problems with Windows installation directory paths

Nobbie wrote:Now Apache sends "something" to the browser, what should the browser show? How will you display that chinese character?

And how is Apache supposed to know, which character set is configured in your browser? You even can change the configuration without sending any request to any server. Is it Apaches fault or the browsers fault if the pathname is not displayed correctly?


In short, it doesn't matter what the user agent shows the user. URIs are for machines; the fact that they're often human-readable is a nice side-effect.

The first Unicode standards document was published in 1991.

As specified back in 1994 by RFC1738 section 2.2 (and "updated" in 2005 by RFC 3986 2.1), "unsafe" characters and characters outside the printable US-ASCII range are URL-encoded, so that's what the user agent and the HTTPd use to communicate. Whether or not the user agent knows how convert the encoded URL to something that is legible to the user is irrelevant; the URL is a valid and correct path, as the encoded URL is the one that the UA and the server use behind the scenes.

*nix filesystems have been able to store filenames with characters outside the ASCII range for forever. (Remember that filenames are almost always to be treated as just a series of bytes!) The URL-encoding scheme (specified in 1994) handles all possible character encodings with ease by treating pathnames as just a series of bytes.

Ideally, an HTTPd running on a system that's known to always use an odd filename encoding (such as Windows, which uses the not-really-UCS-2 encoding informally known as WTF-16) will translate the pathname to UTF-8 before URL encoding it and reverse the translation where appropriate. However, that's certainly not mandatory! All that's needed is for a given path to have a consistent name.

Again: URIs are for machines; the fact that they're often human-readable is a nice side-effect.
by JaneDoe
09. June 2017 21:25
 
Forum: XAMPP for Windows
Topic: Problems with Windows installation directory paths
Replies: 11
Views: 7373

Re: Problems with Windows installation directory paths

Aphid wrote:XAMPP should be able to support any path as its base path or base paths to serve files from, as it really only needs to work with relative paths. E.g. if I want to specify /var/pêcher/ as the path to my French site about Fishing, then that should not be a problem with translating URLs into file paths as the file system path for any particular URL can simply be a relative path 'from' the location in /var/pêcher/. There's no rational reason the base path(s) can't be anything the OS allows as a valid path.


Not a problem? Ok, lets create the following scenario: you are watching a server which is running on a filesystem with utf16 character set. Your browser is configured to use latin1 character set (i.e. ISO-8859-15). A very common configuration. The server contains pathnames with chinese characters, which cannot be displayed with ISO-8859-15, as there is no chinese character in that set. Now Apache sends "something" to the browser, what should the browser show? How will you display that chinese character?

And how is Apache supposed to know, which character set is configured in your browser? You even can change the configuration without sending any request to any server. Is it Apaches fault or the browsers fault if the pathname is not displayed correctly?
by Nobbie
09. June 2017 16:31
 
Forum: XAMPP for Windows
Topic: Problems with Windows installation directory paths
Replies: 11
Views: 7373

Mongodb and Xampp

Dear Admin

I've wonder why we can't add mongodb into xampp ?

According to Mongodb :
What is MongoDB?
MongoDB is an open-source database developed by MongoDB, Inc. MongoDB stores data in JSON-like documents that can vary in structure. Related information is stored together for fast query access through the MongoDB query language. MongoDB uses dynamic schemas, meaning that you can create records without first defining the structure, such as the fields or the types of their values. You can change the structure of records (which we call documents) simply by adding new fields or deleting existing ones. This data model give you the ability to represent hierarchical relationships, to store arrays, and other more complex structures easily. Documents in a collection need not have an identical set of fields and denormalization of data is common. MongoDB was also designed with high availability and scalability in mind, and includes out-of-the-box replication and auto-sharding.

Feature Comparison
Like MySQL, MongoDB offers a rich set of features and functionality far beyond those offered in simple key-value stores. MongoDB has a query language, highly-functional secondary indexes (including text search and geospatial), a powerful aggregation framework for data analysis, and more. With MongoDB you can also make use of these features across more diverse data types than with a relational database, and at scale.

Why use MongoDB instead of MySQL?
Organizations of all sizes are adopting MongoDB because it enables them to build applications faster, handle highly diverse data types, and manage applications more efficiently at scale.

Development is simplified as MongoDB documents map naturally to modern, object-oriented programming languages. Using MongoDB removes the complex object-relational mapping (ORM) layer that translates objects in code to relational tables.

MongoDB’s flexible data model also means that your database schema can evolve with business requirements. For example, schema changes that took days of weeks in The Weather Channel's MySQL databases could be made in just hours with MongoDB.
MongoDB can also be scaled within and across multiple distributed data centers, providing new levels of availability and scalability previously unachievable with relational databases like MySQL. As your deployments grow in terms of data volume and throughput, MongoDB scales easily with no downtime, and without changing your application. In contrast, to achieve scale with MySQL often requires significant, custom engineering work. Baidu migrated from MySQL to MongoDB to support its rapidly growing business. The Chinese internet services giant now powers over 100 apps and manages in excess of 1PB of data with its MongoDB cluster.
source : https://www.mongodb.com/compare/mongodb-mysql


I've already looking for on your site but I can't add new version of mongodb into xampp

Please help me and thanks for your support !

Best Regards.
by jacobi
27. April 2017 02:28
 
Forum: XAMPP for Windows
Topic: Mongodb and Xampp
Replies: 0
Views: 1540

Re: httpd.conf Warning With Mavericks and Above

I unerstand what you want to say. The problem is, that there is so much base knowledge of the same level we might provide.
For example, we might describe that each config setting needs to be placed in it's own line, or that you have to use english ASCII letters and not cyrillic or chinese ones. We might describe that you can only use already configured known config settings and not simply create your own ones.

The problem is where to start and where to end. It is so much to know that really nobody would read and get a benefit of this.
So we choose to not describe it. XAMPP tries to preconfigure everything and we assume that only users with that base knowledge are trying to change anything in the configs theirself.

For everything else there are manuals of the specific components, like for the Apache config files: https://httpd.apache.org/docs/current/e ... uring.html

And at the very end this forum here exists where users (if they are willing) can find your thread or creating their own support thread.
by Altrea
07. May 2016 08:47
 
Forum: XAMPP for Mac OS X
Topic: httpd.conf Warning With Mavericks and Above
Replies: 6
Views: 12077

Re: Hi, new to XAMPP and questions about PHPmyAdmin/MYSQL

Altrea wrote:
WesleyA wrote:Like what?

I don't know. It is your system. You are the only person in the world who could know anything about your system and the things you do.


Yes well that is what I'm fearing now. I also use WAMP but have problems with WAMP running specific apps. The problem started when using the TOR browser a couple of weeks ago. It is the second time in less then a year, I used The Onion Router but this time I kept having problems with WAMP. I meanwhile removed TOR and thought I wouldnt have any problem if I used XAMPP for instance. As a programmer I think it is useful to have alternatives so you can continue programming.

Another issue I have is with hackers, Chinese people who tried to hack me with Microsoft fraude or 'Indische fraude' as it is known here in the Netherlands. When they gain a telephone number you suddenly get telephone calls from India, China or Indonesians or other Asian trying to change to virus scan settings. It is possible that this group of Chinese students or just one Chinese individual studying in Enschede Holland tries to thwart me, pretending they are ethical hackers but in real could be working for a computer fraude gang and yeah my fear is they could be working in project like Apace Friends.

I say it in this way because if your reaction Nobbie is shocking to me. It sounds very personal. If you dont mean it personal then it's fallacious. That would also be serious and is a communication error.

I had the feeling it that there could be a conspiracy of programmers towards me.

That is of course possible but I would like to know more about you and why you say it.

Can you help me with this?
by WesleyA
16. October 2015 14:33
 
Forum: XAMPP for Windows
Topic: Hi, new to XAMPP and questions about PHPmyAdmin/MYSQL
Replies: 14
Views: 5557

Re: Force HTTP redirect to HTTPS

scopa wrote: RewriteCond %{REQUEST_URI} <em><span style="color: red;">folder_name</span></em>


This is horrible nonsense (like mixing english and chinese), I think you first of all should learn about rewriting URLs.

Anyway, i dont get your question, what to do you want to redirect from http to https?
by Nobbie
04. November 2014 16:24
 
Forum: XAMPP for Linux
Topic: Force HTTP redirect to HTTPS
Replies: 1
Views: 1872

mySql can't display Chinese character,alway show like "???"

My OS is 10.9.4,and i installed XAMPP version is 1.8.3-5.my system is display in english and i set up XAMPP is Chinese display in localhost webpage and phpMyadmin also display in Chinese.
So now i faced very strange problem, when i insert Chinese name in the database, the database table is alway show ??? in the database.

    mysql> select * from user1;
    +----+------+----------------------------------+--------------------+-----+
    | id | name | password | email | age |
    +----+------+----------------------------------+--------------------+-----+
    | 2 | xm | 202cb962ac59075b964b07152d234b70 | xiaoming@sohu.com | 34 |
    | 3 | xz | 202cb962ac59075b964b07152d234b70 | xiaozheng@sohu.com | 28 |
    | 4 | ?? | 202cb962ac59075b964b07152d234b70 | xiaoming@sohu.com | 34 |
    | 5 | ??? | 202cb962ac59075b964b07152d234b70 | xiaoming@sohu.com | 34 |
    | 6 | ?? | 202cb962ac59075b964b07152d234b70 | wangying@sohu.com | 13 |
    +----+------+----------------------------------+--------------------+-----+
    5 rows in set (0.03 sec)

after that i type "show variables like '%char%';"

    mysql> show variables like '%char%';
    +--------------------------+------------------------------------------------+
    | Variable_name | Value |
    +--------------------------+------------------------------------------------+
    | character_set_client | utf8 |
    | character_set_connection | utf8 |
    | character_set_database | latin1 |
    | character_set_filesystem | binary |
    | character_set_results | utf8 |
    | character_set_server | latin1 |
    | character_set_system | utf8 |
    | character_sets_dir | /Applications/XAMPP/xamppfiles/share/charsets/ |
    +--------------------------+------------------------------------------------+
    8 rows in set (0.29 sec)
Then i change the "character_set_database" and "character_set_server" both to utf8,after insert a now inform, unfortunate the database still display ???,when i
restart the XMAPP ,the variables table become this again:

    mysql> show variables like '%char%';
    +--------------------------+------------------------------------------------+
    | Variable_name | Value |
    +--------------------------+------------------------------------------------+
    | character_set_client | utf8 |
    | character_set_connection | utf8 |
    | character_set_database | latin1 |
    | character_set_filesystem | binary |
    | character_set_results | utf8 |
    | character_set_server | latin1 |
    | character_set_system | utf8 |
    | character_sets_dir | /Applications/XAMPP/xamppfiles/share/charsets/ |
    +--------------------------+------------------------------------------------+
    8 rows in set (0.29 sec)

So,please help me fix the issure,Thanks a lot.
by elliotxin
13. September 2014 07:26
 
Forum: XAMPP for Mac OS X
Topic: mySql can't display Chinese character,alway show like "???"
Replies: 0
Views: 1271

EXIF Not Rendering Properly Since Moving to 1.8.3

I've been using exif_read_data to display WINXP data from .jpg images. It worked fine under 1.7.2, but since moving to 1.8.3 on Windows 7 I get question marks instead of the proper characters. I've been looking into this for awhile and when I use ini_set('exif.encode_unicode', 'UTF-8'); I get Chinese characters.

It's working on the production server, which uses PHP 5.4, and it *was* working on my XAMPP server until the change to 1.8.3. I've compared the php.ini files, and I can't find a difference that would account for this oddness. I've run out of ideas on what to check.
by Ellsinore
18. May 2014 10:53
 
Forum: XAMPP for Windows
Topic: EXIF Not Rendering Properly Since Moving to 1.8.3
Replies: 0
Views: 885

PHP Form Will Not Update InnoDB

xampp-win32-1.8.3-1-VC11
Windows 8.0 64 bit
Ports I have to use: 8080 & 4443
Running as Administrator, no password
Hello All,
I am using XAMPP for a PHP class and we have example forms and PHP to familiarize ourselves with MYSQL. the form allows entry of animals, the PHP enters the data into the tables. The PHP returns "Added Animals"; however, when the table is searched the animal is not found. My teacher states that "XAMPP is a temporary, portable "mock-server" and is apparently only good for development and demonstration purposes, but PHP and MySQL work better from a real live server when a site is published"

Is this true? The entry just goes through the motions and does not modify the table even though no error was returned? Here is the form; the PHP follows after it; after the PHP are the files to insert to make the DB which must be inserted in the order that they appear. I couldn't figure out the way to attach files, so a notepad document will need to be created from them :

CREATE TABLE SALES & CREATE TABLE SALEANIMALS is missing, too many char

Code: Select all
<html>
 <body>
  <form action="ex2.php" method="post">
   <p>Name: <input type="text" name="name"></p>
   <p>Species: <input type="text" name="species"></p>
   <p>Breed: <input type="text" name="breed"></p>
   <p>Date of Birth: <input type="text" name="dob"></p>
   <p>Gender:
    <select name="gender">
     <option value="Male">Male</option>
     <option value="Female">Female</option>
    </select>
   </p>
   <p>Color: <input type="text" name="color"></p>
   <p>List Price: <input type="text" name="listprice"></p>
   <p><input type="submit" value="Get Data"></p>
  </form>
 </body>
</html>


Code: Select all
<html>
 <body>
  <h1 align="center">Data Entry</h1>
  <?php
   $con = mysql_connect("localhost","root","") or die("Failed to connect to database");
   mysql_select_db("196samples", $con);
   $name = $_POST["name"];
   $species = $_POST["species"];
   $breed = $_POST["breed"];
   $dob = $_POST["dob"];
   $gender = $_POST["gender"];
   $color = $_POST["color"];
   $listprice = $_POST["listprice"];
   $sql_command = "INSERT INTO ANIMALS(NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES " .
    "('" . $name . "','" . $species . "','" . $breed . "','" . $dob . "','" . $gender . "','" . $color . "'," . $listprice . ");";
   echo "<p>$sql_command was executed</p>";
   mysql_query($sql_command);
   echo "<p>Animal added</p>";
   mysql_close($con);
  ?>
 </body>
</html>


[*]
CREATE TABLE ANIMALS
(ANIMALID INTEGER AUTO_INCREMENT,
NAME VARCHAR(40),
SPECIES VARCHAR(40),
BREED VARCHAR(40),
DOB VARCHAR(20),
GENDER VARCHAR(10),
COLOR VARCHAR(40),
LISTPRICE DECIMAL(6,2),
CONSTRAINT pk1 PRIMARY KEY (ANIMALID));

CREATE TABLE CUSTOMERS
(CUSTOMERID INTEGER AUTO_INCREMENT,
PHONE VARCHAR(40),
FIRSTNAME VARCHAR(40),
LASTNAME VARCHAR(40),
ADDRESS VARCHAR(40),
ZIPCODE VARCHAR(5),
CONSTRAINT pk2 PRIMARY KEY (CUSTOMERID));

CREATE TABLE SALES
(SALEID INTEGER AUTO_INCREMENT,
SALEDATE VARCHAR(20),
CUSTOMERID INTEGER,
CONSTRAINT pk3 PRIMARY KEY (SALEID),
CONSTRAINT fk1 FOREIGN KEY (CUSTOMERID) REFERENCES CUSTOMERS(CUSTOMERID));

CREATE TABLE SALEANIMALS
(SALEID INTEGER,
ANIMALID INTEGER,
SALEPRICE DECIMAL(6,2),
CONSTRAINT pk4 PRIMARY KEY (SALEID, ANIMALID),
CONSTRAINT fk3 FOREIGN KEY (ANIMALID) REFERENCES ANIMALS(ANIMALID));
[*]

[*]
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (2,'','Fish','Angel','5/5/2004','Male','Black',12.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (4,'Simon','Dog','Vizsla','3/2/2004','Male','Red Brown',174.06);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (5,'','Fish','Shark','1/1/2004','Female','Gray',22.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (6,'Rosie','Cat','Oriental Shorthair','8/2/2004','Female','Gray',193.31);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (7,'Eugene','Cat','Bombay','1/25/2004','Male','Black',279.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (8,'Miranda','Dog','Norfolk Terrier','5/4/2004','Female','Red',203.75);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (9,'','Fish','Guppy','3/10/2004','Male','Gold',2.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (10,'Sherri','Dog','Siberian Huskie','9/13/2004','Female','Black/White',166.79);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (11,'Susan','Dog','Dalmation','1/22/2004','Female','Spotted',164.96);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (12,'Leisha','Dog','Rottweiler','6/13/2004','Female','Brown',164.06);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (13,'','Fish','Tetra','3/1/2004','Male','Red',12.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (14,'Tina','Cat','Sphynx','1/6/2004','Female','Gold',143.94);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (15,'Bonita','Dog','Cocker Spaniel','10/21/2004','Female','Gold',284.85);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (16,'Lisa','Dog','Great Pyrenees','1/5/2004','Female','Brown',274.35);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (17,'Jackie','Dog','Doberman','4/12/2004','Male','Black',165.73);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (18,'Allison','Cat','Manx','4/21/2004','Female','Black',215.92);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (19,'Gene','Dog','Wire Fox Terrier','5/11/2004','Male','White',210.65);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (20,'Buck','Cat','Bombay','4/30/2004','Male','Black',213.18);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (21,'Debbie','Bird','Cockatiel','1/14/2004','Female','Blue',177.88);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (23,'Craig','Dog','Poodle','3/17/2004','Male','White',108.32);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (24,'Carla','Cat','Maine Coon','4/11/2004','Female','Brown/Red',163.97);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (25,'Vivian','Dog','Cocker Spaniel','4/24/2004','Female','Red',128.18);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (26,'Orville','Dog','Shetland Sheepdog','7/6/2004','Male','Gray',242.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (27,'','Reptile','Gila Monster','3/11/2004','Male','Green',192.08);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (28,'','Spider','Tarantula','2/7/2004','Male','Black',45.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (29,'','Fish','Snail','6/15/2004','Male','White',15.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (30,'Golda','Dog','Bloodhound','1/6/2004','Female','Brown',187.62);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (31,'Taylor','Dog','Mastiff','2/15/2004','Male','Brown',164.70);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (32,'Cathy','Cat','Scottish Fold','6/5/2004','Female','White',138.91);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (33,'Kent','Dog','Poodle-Toy','5/30/2004','Male','Gray/Blue',122.36);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (34,'Rhonda','Dog','Maltipoos','7/16/2004','Female','Gray',199.49);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (35,'Charles','Bird','Parakeet','4/9/2004','Male','Blue/Gold',203.10);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (36,'Connie','Dog','Poodle-Toy','10/14/2004','Female','White',190.46);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (37,'Hunter','Dog','Bassett Hound','5/4/2004','Male','Brown',115.39);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (39,'Doris','Dog','Rottweiler','3/27/2004','Female','Red',211.28);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (40,'Hunter','Dog','Weimaraner','4/2/2004','Male','Brown',214.82);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (41,'Claudia','Dog','Boston Terrier','1/5/2004','Female','Black',179.92);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (42,'Lloyd','Dog','Bassett Hound','5/19/2004','Male','Brown/Black',193.63);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (43,'Chelsea','Reptile','Python','2/10/2004','Female','Black/Gold',237.90);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (44,'Melanie','Dog','Mastiff','6/18/2004','Female','Black',141.17);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (45,'Bernard','Cat','American Shorthair','8/8/2004','Male','Gray',182.77);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (46,'Lou Ann','Dog','Chinese Shar Pei','1/8/2004','Female','Gold',254.85);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (47,'Brian','Dog','Cock A Poo','3/3/2004','Male','Black',206.07);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (48,'Anthony','Cat','Japanese Bobtail','6/16/2004','Male','White',226.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (49,'Martha','Cat','Korat','3/16/2004','Female','Gray/Blue',218.95);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (50,'Arnold','Dog','Pomeranian','5/18/2004','Male','Gray/Blue',267.05);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (51,'Kelly','Dog','Golden Retriever','1/16/2004','Male','Gold',246.05);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (52,'Buck','Dog','St Bernard','1/1/2004','Male','Brown/White',231.44);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (53,'','Fish','Starfish','6/23/2004','Female','Blue',52.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (54,'Sandy','Bird','Parrot','1/23/2004','Female','Blue/Red',107.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (55,'Alice','Dog','Cairn Terrier','1/3/2004','Female','Gray/Blue',204.72);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (56,'Lillie','Cat','Abyssinian','4/3/2004','Female','White',227.39);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (57,'Darcy','Dog','Akita','1/2/2004','Male','White/Black',237.10);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (58,'Curtis','Bird','Parakeet','4/28/2004','Male','Gold/Red',146.87);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (59,'Gaylen','Dog','Dalmation','5/10/2004','Male','Spotted',199.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (60,'Everett','Dog','Australian Shepherd','5/20/2004','Male','Brown/White',325.69);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (61,'Sandy','Dog','Chinese Shar Pei','6/1/2004','Female','Brown',221.55);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (62,'Linda','Cat','Russian Blue','8/22/2004','Female','Gray/Blue',96.73);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (63,'Sandy','Cat','Persian','2/19/2004','Female','White',191.27);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (64,'','Reptile','Python','4/11/2004','Female','Black',255.25);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (65,'Bryce','Cat','Persian','6/23/2004','Male','White/Black',133.24);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (66,'Seth','Cat','Russian Blue','1/9/2004','Male','Gray/Blue',275.10);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (67,'Ara','Cat','Manx','1/29/2004','Male','White',179.05);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (68,'Hoyt','Bird','Parrot','3/28/2004','Male','Blue/Red',235.27);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (69,'Inez','Dog','Border Collie','2/24/2004','Female','Brown/White',104.88);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (70,'Chris','Dog','Akita','2/8/2004','Male','White/Black',206.57);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (71,'Cora','Dog','Keeshond','10/2/2004','Female','Brown',119.67);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (72,'','Mammal','Hamster','6/27/2004','Male','Brown/White',13.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (73,'Janet','Dog','Coon Hound','2/24/2004','Female','Brown',123.65);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (74,'Gina','Dog','Lhasa Apso','1/25/2004','Female','Brown/White',128.08);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (75,'Ella','Dog','Chinese Shar Pei','2/8/2004','Female','Brown',131.83);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (77,'Damon','Cat','Bombay','1/17/2004','Male','Black',178.16);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (78,'Hunter','Dog','Great Dane','1/2/2004','Male','Brown',215.74);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (79,'','Bird','Cockatiel','2/26/2004','Male','Brown/Blue',224.47);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (80,'Oakley','Dog','Jack Russell Terrier','8/9/2004','Female','Brown/White',84.45);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (81,'','Bird','Canary','7/29/2004','Female','Yellow',229.44);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (82,'','Mammal','Ferret','7/21/2004','Male','Brown',125.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (83,'Laura','Dog','Chihuahua','1/25/2004','Female','Brown',155.46);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (84,'Patricia','Cat','Angora','2/26/2004','Female','White',294.26);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (85,'Dwight','Dog','Dachshund','3/3/2004','Male','Brown',178.64);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (86,'','Fish','Tetra','1/2/2004','Female','Black',22.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (87,'Christine','Dog','Norfolk Terrier','8/14/2004','Female','Red',208.12);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (88,'Brandy','Dog','Cocker Spaniel','7/9/2004','Female','Brown',189.06);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (89,'Ben','Dog','German Shepherd','1/10/2004','Male','Black/White',153.94);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (90,'Chad','Dog','Great Dane','6/15/2004','Male','Black',223.97);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (91,'Russell','Dog','Pit Bull','5/23/2004','Male','Brown',171.59);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (92,'Terry','Bird','Lovebird','2/4/2004','Male','White',180.16);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (93,'Trina','Dog','Greyhound','1/5/2004','Female','Gray',143.07);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (94,'Jean','Dog','Siberian Huskie','7/1/2004','Female','White/Brown',223.38);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (95,'Ashley','Cat','Sphynx','1/25/2004','Female','White',183.48);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (96,'Stan','Cat','Sphynx','1/1/2004','Male','Black',241.67);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (97,'Ernest','Dog','Dachshund','1/21/2004','Male','Black',141.95);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (98,'Ricardo','Dog','Bulldog','2/3/2004','Male','Black',177.20);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (99,'','Mammal','Ferret','7/27/2004','Male','Black',230.89);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (100,'Bill','Cat','Scottish Fold','8/6/2004','Male','Gray',132.79);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (101,'Bessie','Dog','Australian Shepherd','1/3/2004','Female','White/Brown',216.10);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (102,'Leonard','Dog','Mastiff','9/18/2004','Male','Brown',197.31);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (103,'Lee','Cat','Siamese','7/17/2004','Male','White/Black',232.90);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (104,'Julie','Cat','Longhair','2/18/2004','Female','Yellow',180.38);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (105,'Beth','Dog','Akita','2/6/2004','Female','White/Brown',177.06);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (106,'Taylor','Cat','Oriental Shorthair','2/21/2004','Male','Yellow/Black',220.94);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (108,'Anissa','Dog','Bloodhound','4/4/2004','Female','Brown',169.13);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (109,'','Fish','Angel','4/5/2004','Female','Yellow',128.22);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (110,'Cathy','Bird','African Grey','7/5/2004','Female','Gray/Red',192.77);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (111,'Martin','Dog','Keeshond','3/8/2004','Male','Black',238.55);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (112,'Elizabeth','Cat','Persian','1/15/2004','Female','Gray',145.33);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (113,'Courtney','Dog','Boston Terrier','3/12/2004','Female','Black',142.61);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (115,'Jewell','Cat','Korat','1/15/2004','Female','Black',210.88);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (116,'','Bird','Parrot','6/1/2004','Male','Blue/Gold',133.01);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (117,'Wallace','Cat','Other','8/9/2004','Male','Brown',50.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (118,'','Fish','Guppy','5/5/2004','Female','Brown',4.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (119,'DuJuan','Reptile','Boa Constrictor','4/26/2004','Male','Brown/Gold',202.56);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (120,'Chester','Dog','Keeshond','2/25/2004','Male','Black',216.91);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (121,'Rachel','Dog','Norfolk Terrier','8/2/2004','Female','Gray',284.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (122,'Gayle','Cat','Bombay','2/14/2004','Female','Black',282.84);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (124,'Trina','Cat','Oriental Shorthair','5/25/2004','Female','Gray',187.70);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (125,'Harlen','Dog','Cocker Spaniel','3/17/2004','Male','Yellow',193.08);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (126,'Pierre','Cat','Maine Coon','4/11/2004','Male','Brown/Yellow',189.27);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (127,'Beth','Cat','British Blue','1/9/2004','Female','Gray/Blue',195.72);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (128,'Henry','Dog','German Shepherd','7/16/2004','Male','Black/White',155.95);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (129,'','Fish','Snail','8/2/2004','Male','Yellow',16.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (130,'Darrell','Dog','Greyhound','7/14/2004','Male','Gray',157.83);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (131,'Elvis','Dog','Mastiff','3/11/2004','Male','Black',214.39);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (132,'Dennis','Cat','Angora','7/13/2004','Male','White',157.01);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (133,'Anissa','Cat','Canadian Hairless','7/13/2004','Female','Gray',328.17);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (134,'','Reptile','Gila Monster','2/8/2004','Male','Brown',182.36);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (135,'','Mammal','Ferret','7/24/2004','Female','Brown',125.23);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (136,'','Bird','Other','8/11/2004','Male','White',206.77);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (137,'','Fish','Shark','1/24/2004','Female','Gray',238.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (138,'Owen','Cat','Japanese Bobtail','5/21/2004','Male','White',232.46);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (139,'Claudia','Dog','Doberman','8/2/2004','Female','Black',220.97);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (140,'Cal','Cat','Persian','7/21/2004','Male','White',134.80);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (141,'MaryJo','Dog','Pit Bull','6/22/2004','Female','Brown',234.51);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (142,'Susan','Dog','Siberian Huskie','8/3/2004','Female','White',180.93);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (143,'Leisha','Cat','Korat','5/20/2004','Female','Brown',163.07);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (144,'Dewey','Dog','Poodle-Toy','5/7/2004','Male','Black',182.60);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (145,'Ruby','Dog','Weimaraner','3/23/2004','Female','Brown',201.85);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (146,'Kevin','Cat','Siamese','3/24/2004','Male','White',93.07);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (147,'Kelly','Dog','Alaskan Malamute','3/25/2004','Male','White',272.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (148,'Wayne','Dog','Akita','2/9/2004','Male','White',257.89);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (149,'Elizabeth','Cat','Tonkinese','6/6/2004','Female','Yellow',138.82);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (150,'Brian','Dog','Norfolk Terrier','1/3/2004','Male','Yellow',168.80);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (151,'Lester','Bird','Parrot','4/9/2004','Male','Red',244.19);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (152,'Heather','Dog','Collie','6/3/2004','Female','Brown/Yellow',218.83);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (153,'Owen','Cat','Manx','6/28/2004','Male','Yellow',234.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (154,'Orville','Dog','English Bulldog','4/15/2004','Male','Yellow',197.01);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (155,'Stephen','Cat','Siamese','2/28/2004','Male','White',222.93);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (156,'Alvin','Dog','Collie','1/21/2004','Male','Yellow',280.59);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (157,'','Bird','Parrot','4/12/2004','Male','Red',237.81);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (158,'Russell','Dog','Shetland Sheepdog','3/20/2004','Male','White/Brown',167.16);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (159,'','Reptile','Python','1/13/2004','Male','Black',141.98);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (160,'Rufus','Dog','Cocker Spaniel','1/2/2004','Male','Yellow/black',176.79);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (161,'Bernard','Dog','Keeshond','5/11/2004','Male','Red',244.90);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (162,'Basil','Cat','Japanese Bobtail','5/8/2004','Male','Red',133.19);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (163,'Bruce','Dog','Jack Russell Terrier','9/20/2004','Male','Brown/White',261.02);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (164,'Ruby','Bird','Parakeet','1/19/2004','Female','Red',253.43);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (165,'Julie','Dog','Dalmation','8/28/2004','Female','Spotted',172.37);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (166,'Katy','Cat','Japanese Bobtail','3/25/2004','Female','Yellow',163.72);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (168,'Ray','Cat','Japanese Bobtail','6/4/2004','Male','Black',225.68);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (169,'Lorene','Dog','Coon Hound','9/11/2004','Female','Yellow',132.48);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (170,'Sarah','Dog','Poodle','3/15/2004','Female','White',250.81);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (171,'Glen','Dog','Chihuahua','4/18/2004','Male','Yellow',232.26);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (172,'Jackie','Dog','Boston Terrier','8/13/2004','Female','Gray',242.28);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (173,'','Mammal','Hamster','6/6/2004','Female','Yellow',22.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (174,'Lisa','Dog','Doberman','2/24/2004','Female','Brown',184.95);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (175,'Donald','Cat','Canadian Hairless','7/9/2004','Male','Brown',193.14);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (176,'DuJuan','Dog','Coon Hound','5/14/2004','Male','Brown',295.28);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (177,'Jennifer','Dog','Siberian Huskie','4/23/2004','Female','White',205.75);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (178,'Leisha','Dog','Scottish Terrier','5/26/2004','Female','Gray',164.63);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (179,'Cassy','Dog','Keeshond','1/5/2004','Female','Red',139.61);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (180,'','Fish','Angel','4/1/2004','Female','Yellow',27.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (181,'','Fish','Tetra','6/16/2004','Male','Brown/Red',23.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (182,'Duane','Dog','Rottweiler','5/28/2004','Male','Red',218.49);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (183,'','Spider','Scorpion','2/2/2004','Male','Black',127.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (184,'','Fish','Tetra','5/21/2004','Male','Black/Blue',25.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (185,'Ricardo','Dog','Airedale','6/21/2004','Male','Gray',164.14);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (186,'Francis','Dog','Chinese Shar Pei','1/29/2004','Female','Brown',240.40);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (187,'Martha','Dog','Poodle','5/15/2004','Female','White',133.65);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (188,'Angela','Dog','Chow Chow','6/26/2004','Female','Yellow',234.97);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (189,'Emma','Bird','Parrot','9/6/2004','Female','Yellow',170.08);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (190,'Wendell','Dog','Minature Pinschers','3/30/2004','Male','Red',163.60);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (191,'Cassy','Dog','Collie','2/13/2004','Female','Brown/White',233.43);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (192,'Sally','Cat','American Shorthair','6/26/2004','Female','Black',196.87);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (193,'Kevin','Cat','Sphynx','9/20/2004','Male','Yellow',240.05);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (195,'Tom','Dog','Dalmation','6/5/2004','Male','Spotted',195.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (196,'Buck','Dog','Doberman','6/5/2004','Male','Black',253.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (197,'','Spider','Tarantula','6/10/2004','Female','Black',221.85);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (198,'Curtis','Dog','Maltese','1/4/2004','Male','Black',142.67);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (199,'Herbert','Cat','Abyssinian','1/23/2004','Male','White',163.73);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (200,'Brandy','Dog','Mastiff','8/1/2004','Female','Brown',120.36);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (201,'','Mammal','Hamster','2/22/2004','Male','Brown',22.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (235,'joe','dog','poodle','4/14/2004','male','white',200.50345);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (345,'John','Dog','Labrador','4/10/2004','Male','Black',350.00);
[*]

[*]
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (1,'','Walkin','Walkin','','00000');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (2,'(808) 801-9830','Brent','Cummings','9197 Hatchet Drive','96815');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (3,'(617) 843-6488','Dwight','Logan','1760 Clearview Street','02109');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (4,'(502) 007-0907','Shatika','Gilbert','4407 Green Street','40342');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (5,'(701) 384-5623','Charlotte','Anderson','4333 Highland Court','58102');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (6,'(606) 740-3304','Searoba','Hopkins','3183 Highland Court','40330');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (7,'(408) 104-9807','Anita','Robinson','8177 Horse Park Lane','95035');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (8,'(606) 688-8141','Cora','Reid','8351 Locust Street','41073');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (9,'(702) 533-3419','Elwood','Henson','4042 West Ridge Drive','89125');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (10,'(302) 701-7398','Kaye','Maynard','5095 Sugar Grove Road','19901');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (11,'(502) 444-1587','Lee','Gentry','5744 High Street','40342');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (12,'(608) 006-2256','Chris','Haley','6087 Spring Street','54601');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (13,'(304) 477-6629','Jolene','Garrison','1830 Glenview Drive','26261');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (14,'(614) 721-2870','Beth','Patterson','3688 Long Hollow Pike','43216');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (15,'(409) 116-3589','Connie','Fisher','4491 Evergreen Circle','77550');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (16,'(502) 863-3037','Rosie','Wade','7661 Trident Place','42240');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (17,'(606) 634-7076','Carly','Embry','2869 Sanders Ferry Road','40383');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (18,'(414) 331-5679','David','Lawrence','9326 Halltown Road','53916');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (19,'(505) 825-4065','Lisa','Zhang','477 Rolling Acres Drive','87501');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (20,'(207) 585-7583','Reva','Kidd','5594 Halltown Road','04401');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (21,'(615) 646-9874','Sarah','Mills','8904 Horseshoe Road','37167');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (22,'(706) 977-4337','Inga','Adkins','8831 Cardinal Lane','30720');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (23,'(606) 084-6983','Jerome','Cummings','2501 Club Circle','41101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (24,'(615) 969-8901','Floyd','Young','969 Windsor Park Lane','37130');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (25,'(502) 863-8898','Gaylen','Wilson','1221 Johnson Drive','40229');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (26,'(606) 691-9745','Trina','Howe','2821 35th Street','40701');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (27,'(608) 825-3740','Archie','Mitchell','1326 Cedar Avenue','53590');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (28,'(408) 575-7000','Gina','Samuels','2026 Homewood Blvd.','95035');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (29,'(802) 078-4749','Kelly','Moore','6116 Clearview Street','05753');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (30,'(919) 014-7544','Rodney','Edmunds','5560 Greenfield Lane','27514');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (31,'(313) 260-7386','Nancy','Froedge','1399 Williamsburg Drive','48152');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (32,'(619) 281-2485','Searoba','Allbright','5260 College Street','92109');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (33,'(314) 510-5228','Colleen','Latham','2864 Dolhous Drive','63366');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (34,'(414) 168-2952','Cathy','Hampton','7295 Hazel Path','53203');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (35,'(406) 987-9338','Kimberly','Adams','5064 Pleasant Valley Drive','59901');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (36,'(501) 071-2650','Lloyd','Holland','9011 Bayshore Drive','72201');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (37,'(517) 039-8300','Fannie','McPherson','4184 Tick Ridge Road','48924');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (38,'(307) 477-8112','Jay','Franklin','9105 Ridge Top Road','82070');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (39,'(304) 352-8602','Dorothy','Williams','9286 Jackson Avenue','25550');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (40,'(612) 089-0074','Darrell','Oberhausen','9556 Cumberland Hills Drive','55101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (41,'(502) 691-7565','Melinda','Craig','9217 Blue Lake Way','40218');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (42,'(615) 041-1934','Jackie','Froedge','243 West Ridge Drive','37027');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (43,'(517) 057-3491','Jasper','Killen','4869 Sequoia Lane','48924');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (44,'(412) 933-3710','Dale','Hammer','9707 Elm Hill Circle','15106');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (45,'(606) 372-0229','Shirley','Gregory','8982 Circle Drive','40356');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (46,'(201) 654-2441','Cassy','Tuck','7977 Fairways Drive','07015');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (47,'(804) 020-5842','Bernice','Carver','8170 Roberts Road','23320');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (48,'(508) 201-2483','Dwight','Parrish','9904 Plum Springs Road','01613');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (49,'(210) 851-7566','Wallace','Galloway','4358 Cherokee Road','78284');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (50,'(704) 979-1610','Lenny','Lee','9940 Girkin Road','28204');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (51,'(715) 483-7737','Clyde','Jernigan','5325 Cherry Street','54022');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (52,'(919) 289-1383','Gladys','Pendleton','1805 Sunset Place','27611');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (53,'(414) 331-5679','David','Lawrence','9326 Halltown Road','53916');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (54,'(502) 971-2715','Mark','Green','8968 Camino Circle','40291');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (55,'(606) 375-0721','Wendell','Thomas','8963 Pine Branch Trace','40330');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (56,'(507) 437-0059','Sidney','Hughes','4386 Sherwood Lane','56007');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (57,'(219) 263-2040','Phillip','Carter','20 Green Street','27514');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (58,'(703) 543-0176','Sam','McCain','445 Industrial Drive','22101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (59,'(360) 917-7520','Cindy','Rhodes','7425 Virginia Street','98501');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (60,'(502) 029-3909','Lou Ann','Baez','2528 Hot Springs Avenue','42718');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (61,'(304) 416-1309','Marvin','McDonald','8045 Lovers Lane','25301');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (62,'(913) 496-1897','Phyllis','Tuck','2150 Volunteer Drive','66502');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (63,'(301) 485-6261','Earl','Grimes','6485 Pepper Street','21701');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (64,'(502) 135-7679','Conrad','Fowler','8114 Cherry Street','42420');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (65,'(817) 528-7955','Linda','Riggs','593 White Oak Court','76101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (66,'(606) 683-4113','Adrian','Greer','6597 Skyline Drive','40422');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (67,'(414) 715-7191','Floyd','Kennedy','3566 Elementary Drive','54305');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (68,'(901) 312-1555','Ella','Kidd','3626 Webster Road','38101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (69,'(919) 205-8147','Mandy','Elliott','4839 Long Hollow Pike','27514');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (70,'(313) 438-8733','Jerry','Poe','5879 Dixie Way','48233');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (71,'(702) 867-1893','Herman','Moseley','4461 Southern Drive','89114');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (72,'(360) 649-9754','Gayle','Bailey','8233 Whisper Woods Road','98201');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (73,'(603) 075-7437','Hershel','Keen','8124 Industrial Drive','03060');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (74,'(606) 241-3182','Frieda','Hinton','9015 Cherokee Road','41042');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (75,'(802) 433-5007','Sharon','Sexton','2551 Elementary Drive','05641');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (76,'(304) 062-1621','Evelyn','Montgomery','6386 Main Street','25550');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (77,'(520) 520-8733','Bart','Gillespie','3422 Breeder Road','85726');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (78,'(505) 646-2748','Elaine','Hall','1790 Cedar Avenue','88310');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (79,'(317) 995-8449','Darcy','Pitts','523 Shoreside Drive','46206');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (80,'(515) 846-5222','Juanita','Vance','8916 High Street','50010');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (81,'(606) 661-2765','Bessie','Baez','7313 Humble Avenue','41031');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (82,'(307) 448-5424','Basil','Davidson','9102 Rocky Mound Road','82071');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (83,'(414) 334-8130','Ada','Jones','4590 Tobacco Road','54956');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (84,'(617) 467-3438','David','Sims','6623 Glenview Drive','02116');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (85,'(502) 595-1052','Glen','Cartwright','448 Sanders Ferry Road','42001');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (86,'(618) 109-9250','Bert','Hooks','9801 Hatchet Drive','62269');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (87,'(606) 793-3172','Lucille','Cummings','1209 Center Point Road','40391');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (88,'(703) 611-2557','Christa','Mallory','6370 N. Main Street','22101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (89,'(308) 873-1375','Kaye','Foster','520 Pace Street','68847');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (90,'(408) 427-2162','Connie','Nichols','4039 Greensburg Street','95035');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (91,'(502) 882-7631','Conrad','Ferguson','6300 Dorcas Drive','40207');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (92,'(608) 481-3369','Tim','Zeller','9682 Ridge Top Road','53701');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (93,'(314) 242-5743','Floyd','Dye','7730 Crosby Drive','63155');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (94,'(802) 458-4329','Dan','Kennedy','3108 Troon Court','05401');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (95,'(715) 140-4710','Clarence','Kinser','6964 Poplar Ridge Road','54701');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (96,'(913) 344-4761','Inez','Maynard','3832 College Street','66502');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (97,'(715) 623-0861','Adam','Rich','2759 Peterson Avenue','54401');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (98,'(701) 691-3002','Wilmer','Pardue','1790 N. Main Street','58102');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (99,'(717) 244-3484','Luther','Bell','5703 Cave Springs Road','17325');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (100,'(606) 326-9807','Reva','Killen','5442 Halltown Road','41056');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (101,'(518)-666-9870','Joe','Man','654 Main Street','52635');
[*]
by mikeses
29. November 2013 18:39
 
Forum: XAMPP for Windows
Topic: PHP Form Will Not Update InnoDB
Replies: 1
Views: 2908

XAMPP / Apache doesn't like Polish language

I have run into very strange issue, when using Javascript-based translation of client-side libraries used in HTML/PHP project served by XAMPP 1.8.1 or Apache under it.

Though I have no idea, why this is happening, it clearly seems that server doesn't like Polish locale file (and only this one). Every time I switch to Polish language, I'm getting "500 Internal Server Error" reported by my browser. Only for this language!

It was confirmed in many separate projects.

For example, I'm using Twitter Bootstrap framework with date picker dropdown, which is localized. It has 38 language files in "js/locales/" folder, named "bootstrap-datepicker.LANGUAGECODE.js" and I can use this date picker with any of the 37 languages except for Polish. Whenever I select Polish, and browser is about to load "bootstrap-datepicker.pl.js" it returns 500.

The same for Redactor library, wysihtml5 editor and so on.

Finally, I have also my own, private project, which uses localization based on i18ltext.com library and it also fails only for Polish language. Up until now, I've added English, German, Chinese and Polish. I can see my application translated to any language, except Polish. Whenever I select it, and browser is about to load (via AJAX) file "c:\XAMPP\htdocs\mobile\public\pg-demo-bootstrap\locales\general.pl.json", it dies with 500. Rest three files in this folder are just fine.

I confirmed that this is XAMPP for Windows or Apache under XAMPP related issue. I have tested all these applications under two different servers (nginx under Linux and Mobile Chrome on my phone) and none of them has this issue -- user can select and use any language.

I also confirmed, that this is not related to contents of this file (some faulty encoding was my first suspicions). I have filled "general.pl.json" with competely different content (once, different language and once completely unrelated content) and XAMPP again failed to load this file. Then I took original, unmodified "general.pl.json" and renamed it to "general.de.json" and when I picked up "German" language in my app, I could see Polish translation, i.e. strings taken from that file.

For some unbelievable reason, XAMPP or Apache under it gets wako, when file name contains "pl.json", "pl.js" or similar. I know, that this is stupid assumption, but evidences can't be denied.

I tried to copy project a little bit up in folder structure (placed copy right below root "htdocs" folder), to test if path length isn't a case here. So faulty file become "http://127.0.0.1/test/locales/general.pl.json". Again, nothing. I can select any language except Polish. When selecting it, project fails with 500 Internal Server Error.

This is a very simple, pure HTML, CSS, JS and jQuery project, no PHP or other server-side library, so possible issues with some incorrect entries in .htaccess file are not the case here. I run it through XAMPP because it contains some AJAX loading, so it would fail, if "index.html" file would be browsed directly, as file:///.

I don't like chasing ghosts and I don't actually believe in them in IT, but it really seems, that XAMPP or Apache has something about Polish language. This is the strangest case I met in IT for past five years or so.

Can someone try to help me and shed some light, where can be possible source of this strange issue?
by trejder
15. July 2013 14:22
 
Forum: XAMPP for Windows
Topic: XAMPP / Apache doesn't like Polish language
Replies: 1
Views: 5242

Re: [BUG] XAMPP 1.8.2 issues

Japanese "security" page is garbled. [Edited] This was because of my php.ini change.
Image

Because navi.php and secuirty.php charactor encoding is "Shift_JIS", but should be converted to be UTF-8.

[Edited] Below is still XAMPP's bug.
And navi.php shows Notice errors, because "lang\jp.php" misses variables below:

Code: Select all
   $TEXT['navi-english'] = "English";
   $TEXT['navi-german'] = "Deutsch";
   $TEXT['navi-spanish'] = "Espal";
   $TEXT['navi-french'] = "Francais";
   $TEXT['navi-italian'] = "Italiano";
   $TEXT['navi-dutch'] = "Nederlands";
   $TEXT['navi-norwegian'] = "Norsk";
   $TEXT['navi-polish'] = "Polski";
   $TEXT['navi-portuguese'] = "Portugu黌";
   $TEXT['navi-slovenian'] = "Slovenian";
   $TEXT['navi-chinese'] = "&#20013;&#25991;";
by kenjis
15. July 2013 09:36
 
Forum: XAMPP for Windows
Topic: [BUG] XAMPP 1.8.2 issues
Replies: 18
Views: 30712

Re: Apache won't start

marco77bb wrote:and the error.log files its chinese to me.

So why don't you show us the file?
by Altrea
17. May 2013 20:12
 
Forum: XAMPP for Windows
Topic: Apache won't start
Replies: 8
Views: 10559

Re: Apache won't start

I tryed to stop the windows ISS7 services , but its the same, it just wont start, and the error.log files its chinese to me.
by marco77bb
17. May 2013 19:42
 
Forum: XAMPP for Windows
Topic: Apache won't start
Replies: 8
Views: 10559

Re: Apache won't start in folders with UTF-8 paths

So is it working?

Do those same .conf files work if you use them in a ISO folder path? (sans the japanese characters) They should - as ASCII and ANSI character sets are subsets of UTF-8.

So I take it that XAMPP in its current form is not Unicode compatible then? Is that a bug or by design?


There is a third possibility you know - omission - no one expected an English distribution to be used on a non-latinate filesystem when they were writing the configuration files :shock:

What is UTF-8, exactly? OK, you don't have to know this to get CityDesk to work, but you may be wondering, so we'll try to explain it here.

In the olden days computers used 8 bits to store a letter. There are 256 possible combinations of 8 bits. That's enough for many languages, but not enough for Asian languages like Chinese which have thousands of different "letters." There were many different incompatible encoding schemes for jamming different alphabets into the same 256 combinations. The most common format, ASCII, defined what would happen in the first 127 combinations, but it was only good enough for English.

To simplify the problem a consortium of computer makers came up with an international standard called Unicode. Under Unicode, you would use 16 bits to store a letter. That gives you room for 65,536 different letters, which is enough for just about every known alphabet all at once, making multilingual text on computers possible.

The trouble is that all the people who spoke English were distracted that they would have to "waste" an extra 8 bits on each letter even when they were just writing in English. And besides, there were already a lot of existing computer systems that assumed 8 bits = 1 letter. So the Unicode Consortium came up with a scheme called UTF-8. In this scheme, all English language letters (and indeed, all characters below 128 from the old fashioned ASCII character set) would be written out exactly the same way as before. Only non-English letters would be encoded using between 2 and 6 bytes. This scheme is the most popular method of encoding Unicode on the Internet.

The details, of course, are somewhat more complicated than this, and in fact, this is a rather grotesque oversimplification, but we've probably already bored you to tears so we'll move on now.


http://www.fogcreek.com/citydesk/2.0/he ... etiss.html

http://stackoverflow.com/questions/7018 ... nsi-format

Good Luck
8)
by JonB
22. February 2013 21:16
 
Forum: XAMPP for Windows
Topic: Apache won't start in folders with UTF-8 paths [Answered]
Replies: 9
Views: 12065
Next

Return to advanced search