In Feburary 2016 30,
All articles made in China should be avoided because they can insult and be inappropriate. Your Chinese guest is interested in what is here, not back home--your gift should remind him of a positive experience here. Giving a clock as a gift to a Chinese visitor is a cultural faux pas because the Chinese word for 'clock' is similar to the word for 'death.' Likewise, all sharp instruments such as scissors, letter openers and knives should be avoided, as they tell your Chinese visitor in dramatic form that you wish to sever your relationship. Never give a fan to your Chinese guest because the word for 'fan' resembles the Chinese word for 'separation,' which gives the message that you intend to end the friendship. A green hat for a man is taboo because in China it means the man's wife is adulterous. Surprisingly, a book would not be a good idea for a visitor from Hong Kong since the pronunciation of 'book' in Cantonese resembles the sound of 'loss.' Umbrellas, for similar reasons, are also to be avoided for any Chinese visitor. Although you should aim for quality with your gift-giving, refrain from spending too much to avoid embarrassing your guest.
Tourist Shopping Behavior
A good way to assess what gift might be prized by a Chinese visitor is to consider what Chinese tourists buy for themselves and their friends. Popular items are favorites over unique or unusual items. Status items--associated with sports celebrities, political leaders or film stars--are also favorite purchases. Chinese people do like to show off luxury, so branded or designer items end up in their shopping bags. Goods that are associated with festivals, local folklore and special athletic, musical, artistic or cultural events are also prized.
Gift Ideas
Given the Chinese visitor's personal preferences, a baseball or football cap and T-shirt are good gifts, even for business clients. Parker pens are famous in China and, together with leather wallets, make good choices. Giving wine, especially white or rose wines, is also an appropriate gift. Any gift that represents your city, state or region would make a fine choice, as long as it was not made in China. The Chinese are curious about the world outside China and its special customs and goods. Also, they prize art. Your gift need not be an expensive oil painting. Large, full-colored picture books of American art or coffee-table photography books with pictures of local American towns make good gifts. Giving tickets to a special event is also something to be considered because some visitors like to engage in activities frowned upon or nonexistent at home. If you know your visitor well, consider a cabaret show or a night at the casino.
Gift-Giving Tips
When presenting your gift, use two hands, not one. Insist on it being received, even if your Chinese visitor refuses several times to accept it. And, never wrap it in white, blue or black paper. Red is a good color for gift wrap. In addition, do not give single or odd-numbered gifts. Gifts in pairs or even numbers will not offend your visitor.
In Feburary 2016 30,
Posts mit dem Label avoid werden angezeigt. Alle Posts anzeigen
Posts mit dem Label avoid werden angezeigt. Alle Posts anzeigen
Dienstag, 1. März 2016
Dienstag, 9. Februar 2016
MySQL: How to Insert Auto IncrementsIn Feburary 2016 09,
In Feburary 2016 09,
Identify the fields and tables in the database where auto-increment fields are required. Auto-increment fields are normally used as a primary key in a table or part of the primary key. If it is not possible to put the auto-increment value in an existing table, consider creating a new table.
Create a table by writing out the Data Manipulation Commands (DML) in a text file in MySQL format. Choose a suitable auto-incremental field to use for your requirements. Auto increment fields should have the 'NOT NULL' attribute associated with them to avoid potential problems in the database.The following is an example table with the first field, 'trackingid,' set as the auto-increment field. Every time a record is inserted into the table, the field is automatically incremented in the database. In this case, both the 'trackingid' fields and the 'customerid' field are the primary key.CREATE TABLE itemorder (
trackingid INT(8) AUTO_INCREMENT NOT NULL,customerid INT(8) NOT NULL,staffid INT(8) NOT NULL,serviceid INT(8) NOT NULL,itemdescription VARCHAR(100) NOT NULL,destinationid INT(8) NOT NULL,weightclass INT(1) NOT NULL,deliverytime INT(1) NOT NULL,deliverycost DECIMAL(9,2) NOT NULL,trackstatus VARCHAR(30) NOT NULL,lasttracked DATE NOT NULL,PRIMARY KEY (trackingid, customerid)
);
Set the starting value of the auto increments. The default value of the auto incremental is normally '1,' which can be changed by altering the table statement for the increment. In the following example, it has been set to start at '100.' The alter table statement usually occurs after the table has been created.ALTER TABLE itemorder AUTO_INCREMENT = 100;
Run 'Insert' statements on the MySQL command line or in an SQL file to the insert records into the table. The auto-increment field will automatically be updated in the table. The following example shows allows this can be achieved.INSERT INTO itemorder (customerid, staffid, serviceid, itemdescription, destinationid, weightclass, deliverytime, deliverycost, trackstatus, lasttracked)
VALUES ('5','234','98','headphones','789','14','7',9.65,'Order Received','16-05-2011');
The 'trackingid' field has been ignored in the field list, as it does not need to be included. It will be added automatically because it is an auto increment field.Therefore, if the starting value is '100,' the next value inserted into the auto increment field 'trackingid' will be '101.'
In Feburary 2016 09,
Identify the fields and tables in the database where auto-increment fields are required. Auto-increment fields are normally used as a primary key in a table or part of the primary key. If it is not possible to put the auto-increment value in an existing table, consider creating a new table.
Create a table by writing out the Data Manipulation Commands (DML) in a text file in MySQL format. Choose a suitable auto-incremental field to use for your requirements. Auto increment fields should have the 'NOT NULL' attribute associated with them to avoid potential problems in the database.The following is an example table with the first field, 'trackingid,' set as the auto-increment field. Every time a record is inserted into the table, the field is automatically incremented in the database. In this case, both the 'trackingid' fields and the 'customerid' field are the primary key.CREATE TABLE itemorder (
trackingid INT(8) AUTO_INCREMENT NOT NULL,customerid INT(8) NOT NULL,staffid INT(8) NOT NULL,serviceid INT(8) NOT NULL,itemdescription VARCHAR(100) NOT NULL,destinationid INT(8) NOT NULL,weightclass INT(1) NOT NULL,deliverytime INT(1) NOT NULL,deliverycost DECIMAL(9,2) NOT NULL,trackstatus VARCHAR(30) NOT NULL,lasttracked DATE NOT NULL,PRIMARY KEY (trackingid, customerid)
);
Set the starting value of the auto increments. The default value of the auto incremental is normally '1,' which can be changed by altering the table statement for the increment. In the following example, it has been set to start at '100.' The alter table statement usually occurs after the table has been created.ALTER TABLE itemorder AUTO_INCREMENT = 100;
Run 'Insert' statements on the MySQL command line or in an SQL file to the insert records into the table. The auto-increment field will automatically be updated in the table. The following example shows allows this can be achieved.INSERT INTO itemorder (customerid, staffid, serviceid, itemdescription, destinationid, weightclass, deliverytime, deliverycost, trackstatus, lasttracked)
VALUES ('5','234','98','headphones','789','14','7',9.65,'Order Received','16-05-2011');
The 'trackingid' field has been ignored in the field list, as it does not need to be included. It will be added automatically because it is an auto increment field.Therefore, if the starting value is '100,' the next value inserted into the auto increment field 'trackingid' will be '101.'
In Feburary 2016 09,
Donnerstag, 4. Februar 2016
What Is Domain Hosting?In Feburary 2016 04,
In Feburary 2016 04,
Domain hosting, also known as website hosting or DNS hosting, can best be described this way: if a website is a home, and a web address is the street address, then a domain host is the land a home sits on.
Domain hosting is an Internet service provided by a DNS (Domain Name System) server. The DNS server, in simple terms, is a large capacity computer that stores files. It is connected to the Internet, where web surfers can access the files, including the web pages, that make up a website. When a domain name is purchased, it and the domain server that will host the site is registered with ICANN (Internet Corporation for Assigned Names and Numbers), who in turn ensures that anyone who types in the domain is directed to the correct server.
Most small to mid-size websites are hosted on virtual servers. A virtual server may host more than one website, and shares its space and resources among those sites. The only drawback to that situation occurs when there is unusually high traffic to one of the websites on the server. That traffic may slow down access to the other websites on the server.
Dedicated DNS Servers
Unlike a virtual DNS server, a dedicated DNS server is set aside by the hosting provider to host a single website and all associated files. This ensures that the server only has to deal with traffic to their own website, and nothing else. This is often the best choice for large companies, who do not want to share server speed and resources with other websites.
Reliability
Because there are varying degrees of quality among computer servers, there are varying degrees of reliability and service among providers. Before deciding which domain hosting provider will host a website, an owner should research the reputation and guarantees associated with a domain hosting provider.
Customer complaints towards a company are easy to find via Internet searches. In particular, avoid companies whose customers complain about busy or down servers. Older servers often crash or get congested with too much traffic, especially with today's high speed Internet access. Some domain hosting providers promise 100 percent 'up' time, because they have backup servers that will keep your website online if the primary server goes down. Beware of new hosting providers that 'pop up' overnight offering low prices. They could easily fold, leaving a website owner with a website that is offline. There are a number of hosting providers to choose from that have strong track records of service.
Purchasing DNS Hosting
A number of companies offer domain hosting services. These services are often bundled with domain registration and design, offering a website owner a 'one stop' source for all of their needs. However, an owner should beware that these 'bundles' are often priced much higher, and the same services purchased separately could result in large savings.
A website owner can even purchase the services separately from different companies; it is not necessary to have domain registration, site design, and hosting all from the same provider. However, a website owner should consult with any companies providing services to ensure proper registration and hosting information is provided correctly to avoid a lapse in service.
Domain hosting providers offer different plans, depending on the size and content of a website and the traffic it will attract. Hosting plans offer a certain amount of space on the server for a site's web pages and content. Simple websites with only a few pages and limited graphics and media files may only need a plan with 50 MB (megabytes) of space. Larger websites with a number of media files and pages may need plans which offer space in gigabytes. Most domain hosting plans offer software which allows an owner to keep track of how much space a site is using, often allowing for additional space to be purchased as the site grows.
Some plans charge based on the rate of data transfer, which measures how many people visit a website and load pages and content. This includes larger files like pictures, and audio and video, so a website that offers this kind of content will have a much higher rate of data transfer.
Many hosting companies charge a flat rate for a certain amount of data transfer during a week or a month, with additional charges if that level is exceeded. A good hosting company will allow a website owner to 'upgrade' to another plan with better rates if website traffic grows along with data transfer. If high data transfer is an issue, consider a hosting provider that offers unlimited data transfer. These plans do cost a premium, but under the right circumstances, can lead to significant savings.
A website owner should also research how a hosting provider handles uploads of content and changes to a website. Most offer simple programs of various kinds (often dependent on the operating system used, like Linux or Windows) to make uploads quick and easy. Website owners with a designated webmaster should seek their advice on which hosting provider will make their job easier.
Sign up and purchase of a domain hosting plan is often simple, usually akin to making a regular online purchase. Most hosting providers provide a customer service number to provide live help in initially setting up a site.
Free DNS Hosting
If a website owner cannot afford to invest in a hosting service, there are other options. Some websites offer free website domain hosting on their servers. An Internet search using the term 'free website hosting' will bring up a number of choices. These free hosting plans tend to include mandatory ads which will run on a website. For very simple websites for individuals or very small businesses, this could be the best option. These websites also offer low cost hosting services for websites that need more space, or want to get rid of ads.
With proper research and an understanding of the products offered, a website owner can find a hosting provider that not only meets a site's needs, but can adapt as the site grows.
In Feburary 2016 04,
Domain hosting, also known as website hosting or DNS hosting, can best be described this way: if a website is a home, and a web address is the street address, then a domain host is the land a home sits on.
Domain hosting is an Internet service provided by a DNS (Domain Name System) server. The DNS server, in simple terms, is a large capacity computer that stores files. It is connected to the Internet, where web surfers can access the files, including the web pages, that make up a website. When a domain name is purchased, it and the domain server that will host the site is registered with ICANN (Internet Corporation for Assigned Names and Numbers), who in turn ensures that anyone who types in the domain is directed to the correct server.
Most small to mid-size websites are hosted on virtual servers. A virtual server may host more than one website, and shares its space and resources among those sites. The only drawback to that situation occurs when there is unusually high traffic to one of the websites on the server. That traffic may slow down access to the other websites on the server.
Dedicated DNS Servers
Unlike a virtual DNS server, a dedicated DNS server is set aside by the hosting provider to host a single website and all associated files. This ensures that the server only has to deal with traffic to their own website, and nothing else. This is often the best choice for large companies, who do not want to share server speed and resources with other websites.
Reliability
Because there are varying degrees of quality among computer servers, there are varying degrees of reliability and service among providers. Before deciding which domain hosting provider will host a website, an owner should research the reputation and guarantees associated with a domain hosting provider.
Customer complaints towards a company are easy to find via Internet searches. In particular, avoid companies whose customers complain about busy or down servers. Older servers often crash or get congested with too much traffic, especially with today's high speed Internet access. Some domain hosting providers promise 100 percent 'up' time, because they have backup servers that will keep your website online if the primary server goes down. Beware of new hosting providers that 'pop up' overnight offering low prices. They could easily fold, leaving a website owner with a website that is offline. There are a number of hosting providers to choose from that have strong track records of service.
Purchasing DNS Hosting
A number of companies offer domain hosting services. These services are often bundled with domain registration and design, offering a website owner a 'one stop' source for all of their needs. However, an owner should beware that these 'bundles' are often priced much higher, and the same services purchased separately could result in large savings.
A website owner can even purchase the services separately from different companies; it is not necessary to have domain registration, site design, and hosting all from the same provider. However, a website owner should consult with any companies providing services to ensure proper registration and hosting information is provided correctly to avoid a lapse in service.
Domain hosting providers offer different plans, depending on the size and content of a website and the traffic it will attract. Hosting plans offer a certain amount of space on the server for a site's web pages and content. Simple websites with only a few pages and limited graphics and media files may only need a plan with 50 MB (megabytes) of space. Larger websites with a number of media files and pages may need plans which offer space in gigabytes. Most domain hosting plans offer software which allows an owner to keep track of how much space a site is using, often allowing for additional space to be purchased as the site grows.
Some plans charge based on the rate of data transfer, which measures how many people visit a website and load pages and content. This includes larger files like pictures, and audio and video, so a website that offers this kind of content will have a much higher rate of data transfer.
Many hosting companies charge a flat rate for a certain amount of data transfer during a week or a month, with additional charges if that level is exceeded. A good hosting company will allow a website owner to 'upgrade' to another plan with better rates if website traffic grows along with data transfer. If high data transfer is an issue, consider a hosting provider that offers unlimited data transfer. These plans do cost a premium, but under the right circumstances, can lead to significant savings.
A website owner should also research how a hosting provider handles uploads of content and changes to a website. Most offer simple programs of various kinds (often dependent on the operating system used, like Linux or Windows) to make uploads quick and easy. Website owners with a designated webmaster should seek their advice on which hosting provider will make their job easier.
Sign up and purchase of a domain hosting plan is often simple, usually akin to making a regular online purchase. Most hosting providers provide a customer service number to provide live help in initially setting up a site.
Free DNS Hosting
If a website owner cannot afford to invest in a hosting service, there are other options. Some websites offer free website domain hosting on their servers. An Internet search using the term 'free website hosting' will bring up a number of choices. These free hosting plans tend to include mandatory ads which will run on a website. For very simple websites for individuals or very small businesses, this could be the best option. These websites also offer low cost hosting services for websites that need more space, or want to get rid of ads.
With proper research and an understanding of the products offered, a website owner can find a hosting provider that not only meets a site's needs, but can adapt as the site grows.
In Feburary 2016 04,
Abonnieren
Posts (Atom)