Another useful string function in MySQL database is TRIM() which will return a text string after removing the matching leading or trailing characters, also known as prefixes or suffixes. It’s been described by MySQL reference as function that returns the string str with all remstr prefixes or suffixes removed. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed. remstr is […]
MySQL database has a handy and simple string function REPLACE() that allows table data with the matching string (from_string) to be replaced by new string (to_string). This is useful if there is need to search and replace a text string which affects many records or rows, such as change of company name, postcode, URL or spelling mistake.
Windows Vista by default applies ClearType effect to the fonts displayed on screen, in order to improve the appearance of text on certain types of computer display screens, especially LCD flat-panel monitors. As ClearType text actually sacrifices color or chrominance details aspect of image quality for light and dark or luminance detail, some people may not like the blurry font style in ClearType. Here’s a […]
Samsung recently showcased its new IPTV set-top box in Cebit, held in Hannover, Germany last month. This set-top box, known as SMT-H6155 supports 802.11n wireless connectivity that can stream High Definition (HD) media to other digital devices in the home. 802.11n, is a revolution from 802.11b/g wifi technology which support high bandwidth of more than 100 Mbps!
Recently, NEC unveiled a new 3.5-inch LCD display for mobile devices that offers 220cdpm² luminance – 130% brighter than current transmissive LCDs which can reproduce colours “clearly and vividly” in bright conditions.
In Apache web server, when an administrator wants to check the Apache server status with the command “apachectl status” or “service httpd fullstatus” at shell prompt, the following error may occur: Not Found The requested URL /server-status was not found on this server.
There are many possible way to turn off or turn on User Access Control (UAC) in Windows Vista, which frequently pop up a confirmation dialog window to asking for permissions to continue a task which requires elevated administrator rights. Normally UAC cannot be enabled or disabled by using GUI-based Control Panel. For programmers or developers, it may be useful to be able to enable or […]
“Speed Dial” is a quite useful feature in mobile phone. It gives you convenience to dial your favorite numbers. The same feature is now applicable to the latest version of Opera’s web browser (Version 9.2), Net users can use the Speed Dial feature to call up the top sites that they enjoy throughout the day!
The debate over digital piracy and video sharing could now be reshaped with Adobe’s first move to unveil its video player software which can allow consumers to play back video online or offline. The soon to be released Adobe Video Player builds on the leading design software maker’s Flash player, already the dominant technology used to stream video online by sites ranging from YouTube to […]
The Windows Server 2003 Service Pack 1 (SP1) Administration Tools Pack provides server management tools that allow administrators to remotely manage computers running Windows 2000 Server and Windows Server 2003 family operating systems, while newer Windows Server 2003 R2 AdminPack provides utilities that allow system admins to remotely manage features specific to Wndows Server 2003 R2 on computers running Windows Server 2003 R2 family of […]
Microsoft has released an updated version 6.0 of Remote Desktop Connection (Terminal Services Client) for Windows XP and Windows 2003. Remote Desktop Connection 6.0 client update will allow RDP users to use the new Terminal Services features that are introduced in Windows Vista and in the Microsoft Windows Server Code Name “Longhorn” operating system from a computer that is either running Microsoft Windows Server 2003 […]
AG Neovo V-10 FotoVivo, a new digital photo frame is a product that emphasizes on closing the gap that most high-end IT products brought to the market. The Neovo FotoVivo’s glossy finish design in the front with a captivating curve in the rear makes the exterior perfectly aesthetically appealing. In addition, the simple and glossy finish is combined with a button-less “touchable frame” that lets […]
Tip and Trick