Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The IntlChar getUnicodeVersion() function is used to get the Unicode version.Syntaxarray IntlChar::getUnicodeVersion ()ParametersNAReturnThe IntlChar getUnicodeVersion() function returns thearray containing the Unicode version number.ExampleThe following is an example −OutputThe following is the output −array(4) { [0]=> int(6) [1]=> int(3) [2]=> int(0) [3]=> int(0) }
Let us first create a table −mysql> create table DemoTable1946 ( ShippingDate date ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1946 values('2019-12-11'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1946 values('2018-12-11'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1946 values('2017-12-11'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1946 values('2019-04-22'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1946 values('2019-12-11'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1946 values('2015-12-11'); Query OK, 1 ... Read More
The IntlChar digit() function is used to display the decimal digit value of a code point for a given radix.Syntaxint IntlChar::digit( $val, $radix )Parametersval − An integer or character encoded as a UTF-8 string.radix − The radix value. Default is 10.ReturnThe IntlChar digit() function returns the number represented by the character in the given radix.ExampleThe following is an example −OutputThe following is the output −int(2) bool(false) bool(false)
The IntlChar isdefined() function checks whether the entered value is defined or not.Syntaxbool IntlChar::isdefined (val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar isdefined() function returns TRUE if val is a defined character.ExampleThe following is an example −OutputThe following is the output −bool(true) bool(true) NULL NULL
The IntlChar charType() function is used to get the general category value for the entered value.Syntaxint IntlChar::charType (val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar charType()function returns the following general category content −IntlChar::CHAR_CATEGORY_UNASSIGNEDIntlChar::CHAR_CATEGORY_GENERAL_OTHER_TYPESIntlChar::CHAR_CATEGORY_UPPERCASE_LETTERIntlChar::CHAR_CATEGORY_LOWERCASE_LETTERIntlChar::CHAR_CATEGORY_TITLECASE_LETTERIntlChar::CHAR_CATEGORY_MODIFIER_LETTERIntlChar::CHAR_CATEGORY_OTHER_LETTERIntlChar::CHAR_CATEGORY_NON_SPACING_MARKIntlChar::CHAR_CATEGORY_ENCLOSING_MARKIntlChar::CHAR_CATEGORY_COMBINING_SPACING_MARKIntlChar::CHAR_CATEGORY_DECIMAL_DIGIT_NUMBERIntlChar::CHAR_CATEGORY_LETTER_NUMBERIntlChar::CHAR_CATEGORY_OTHER_NUMBERIntlChar::CHAR_CATEGORY_SPACE_SEPARATORIntlChar::CHAR_CATEGORY_LINE_SEPARATORIntlChar::CHAR_CATEGORY_PARAGRAPH_SEPARATORIntlChar::CHAR_CATEGORY_CONTROL_CHARIntlChar::CHAR_CATEGORY_FORMAT_CHARIntlChar::CHAR_CATEGORY_PRIVATE_USE_CHARIntlChar::CHAR_CATEGORY_SURROGATEIntlChar::CHAR_CATEGORY_DASH_PUNCTUATIONIntlChar::CHAR_CATEGORY_START_PUNCTUATIONIntlChar::CHAR_CATEGORY_END_PUNCTUATIONIntlChar::CHAR_CATEGORY_CONNECTOR_PUNCTUATIONIntlChar::CHAR_CATEGORY_OTHER_PUNCTUATIONIntlChar::CHAR_CATEGORY_MATH_SYMBOLIntlChar::CHAR_CATEGORY_CURRENCY_SYMBOLIntlChar::CHAR_CATEGORY_MODIFIER_SYMBOLIntlChar::CHAR_CATEGORY_OTHER_SYMBOLIntlChar::CHAR_CATEGORY_INITIAL_PUNCTUATIONIntlChar::CHAR_CATEGORY_FINAL_PUNCTUATIONIntlChar::CHAR_CATEGORY_CHAR_CATEGORY_COUNTExampleThe following is an example −OutputThe following is the output −bool(false) bool(false) bool(false) bool(true) bool(true)Read More
The stop() method in jQuery is used to stop an animation before it ends.SyntaxThe syntax is as follows −$(selector).stop(stopAll, goToEnd);Above, stopAll clears all animation, whereas gotoEnd is used to specify whether to complete the current animation immediately or not.ExampleLet us now see an example to implement the jQuery stop() method − Live Demo $(document).ready(function(){ $(".button1").click(function(){ var div = $("div"); div.animate({height: 250}, "slow"); div.animate({left: "+=200", top: "+=100" }, "slow"); div.queue(function(){ div.dequeue(); ... Read More
The IntlChar charDirection() function is used to display the the bidirectional category value for the entered value.Syntaxint IntlChar::charDirection(val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar charDirection() function returns the following bidirectional category value −IntlChar::CHAR_DIRECTION_LEFT_TO_RIGHTIntlChar::CHAR_DIRECTION_RIGHT_TO_LEFTIntlChar::CHAR_DIRECTION_EUROPEAN_NUMBERIntlChar::CHAR_DIRECTION_EUROPEAN_NUMBER_SEPARATORIntlChar::CHAR_DIRECTION_EUROPEAN_NUMBER_TERMINATORIntlChar::CHAR_DIRECTION_ARABIC_NUMBERIntlChar::CHAR_DIRECTION_COMMON_NUMBER_SEPARATORIntlChar::CHAR_DIRECTION_BLOCK_SEPARATORIntlChar::CHAR_DIRECTION_SEGMENT_SEPARATORIntlChar::CHAR_DIRECTION_WHITE_SPACE_NEUTRALIntlChar::CHAR_DIRECTION_OTHER_NEUTRALIntlChar::CHAR_DIRECTION_LEFT_TO_RIGHT_EMBEDDINGIntlChar::CHAR_DIRECTION_LEFT_TO_RIGHT_OVERRIDEIntlChar::CHAR_DIRECTION_RIGHT_TO_LEFT_ARABICIntlChar::CHAR_DIRECTION_RIGHT_TO_LEFT_EMBEDDINGIntlChar::CHAR_DIRECTION_RIGHT_TO_LEFT_OVERRIDEIntlChar::CHAR_DIRECTION_POP_DIRECTIONAL_FORMATIntlChar::CHAR_DIRECTION_DIR_NON_SPACING_MARKIntlChar::CHAR_DIRECTION_BOUNDARY_NEUTRALIntlChar::CHAR_DIRECTION_FIRST_STRONG_ISOLATEIntlChar::CHAR_DIRECTION_LEFT_TO_RIGHT_ISOLATEIntlChar::CHAR_DIRECTION_RIGHT_TO_LEFT_ISOLATEIntlChar::CHAR_DIRECTION_POP_DIRECTIONAL_ISOLATEIntlChar::CHAR_DIRECTION_CHAR_DIRECTION_COUNTExampleThe following is an example −OutputThe following is the output −int(3) int(10) NULL int(0)Read More
The IntlChar tolower() function converts the character into Unicode character lowercase.SyntaxIntlChar::tolower (val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar tolower() function returns the converted lowercas character. If the character is already in lowercase, the same character is returned.ExampleThe following is an example −OutputThe following is the output −string(1) "J" NULL string(1) "J" NULL
The IntlChar toupper()function converts the character into Unicode character uppercase.SyntaxIntlChar::toupper (val)Parametersval − An integer or character encoded as a UTF-8 string.ReturnThe IntlChar toupper()function returns the converted uppercase character. If the character is already in uppercase, the same character is returned.ExampleThe following is an example −OutputThe following is the output −string(1) "J" NULL string(1) "J" NULL
To insert records from multiple tables, use INSERT INTO SELECT statement. Here, we will insert records from 2 tables.Let us first create a table −mysql> create table DemoTable1943 ( Name varchar(20) ); Query OK, 0 rows affected (0.00 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1943 values('Chris'); Query OK, 1 row affected (0.00 sec) mysql> insert into DemoTable1943 values('Robert'); Query OK, 1 row affected (0.00 sec)Display all records from the table using select statement −mysql> select * from DemoTable1943;This will produce the following output −+--------+ | Name | +--------+ | Chris ... Read More