MySQL database -language
Title
Question
sir, while storing data in MySQL database I tried to store data in language tamil, that is the data is of tamil script. the DB successfully accepted them. But When I view in phpMyadmin's GUI page, the values(tamil scripts are )are encrypted in some other form and I can only see the encrypted form.
But when I retrieved from the DB using mysql_query() and mysql_fetch_array() I saw the original tamil script. Though it is, the length of the field is not enough to store the actual number of characters(i.e name varchar(10), stores only three tamil characters but 10 english characters).
My questions are all about the language! I hope you will help me below are my questions. please help me !!!
1) Can I store data in my mother tongue (or Is any Indian regional language is compatible with MySql) if so how??? (Note: I am not speaking about the translation, but the originality of storing raw regional lanuage script...)
PHP-and-MySQL MySQL-Part-1
Answers:
Your character set should be set to UTF-8.
Example:
CREATE TABLE `MyLanguage`
(
`id` int(10) NOT NULL AUTO_INCREMENT,
`tamil_language_text` varchar(300) CHARACTER SET utf8 collate utf8_general_ci ,
`tamil_more_text` text CHARACTER SET utf8 collate utf8_general_ci,
PRIMARY KEY (`id`)
)
<span class="Apple-style-span" style="background-color: white; font-family: 'Courier New', Courier, monospace; font-size: 13px; line-height: 16px;"></span>
Example:
CREATE TABLE `MyLanguage`
(
`id` int(10) NOT NULL AUTO_INCREMENT,
`tamil_language_text` varchar(300) CHARACTER SET utf8 collate utf8_general_ci ,
`tamil_more_text` text CHARACTER SET utf8 collate utf8_general_ci,
PRIMARY KEY (`id`)
)
<span class="Apple-style-span" style="background-color: white; font-family: 'Courier New', Courier, monospace; font-size: 13px; line-height: 16px;"></span>
Thank you! sir/madam, I will try this today . Also, I think I may need your help again please help me ! I will come up with new question next time.
Hello sir, Of course as you said I set the character set to utf-8 , Now I can see tamil text on the database also I can store and retrieve succfully.
I enjoyed your "visitor counter" program.
As part of our discussion I want to know about the perl regular expressions i.e the preg() functions. In validation like email and password we use preg() and its related functions. What my silly doubt is ,
We so far use the username ,password fields in most of our tutorials. particularly I used to practice in such a way that the password field might contain at least 8 characters, at least an Uppercase letter,at least a special character.
suppose If I have a website in my mother language like tamil (or probably be any of our Indian language... ) and in which I use a form with all field names in tamil , I expect the username and password in tamil itself so, can I able to validate the password field above with preg() functions??? Clearly, as per my expectation my user is going to type in the password field in tamil characters, incase he/she used other language (english, etc....) , my form might give him an error use only tamil or hindi or what ever the language may be... also others of my validation conditions. Is it possible in php????
I think I may clearly put forth my question to you, but if its not clear please give me a chance I will come up with screen shorts tomorrow.
if no please explain me why??? (.... is perl regular for only english??? ) also if yes please explain me how!
Waiting for your answer sir, ... thank you for your previous answers meet you again!
I enjoyed your "visitor counter" program.
As part of our discussion I want to know about the perl regular expressions i.e the preg() functions. In validation like email and password we use preg() and its related functions. What my silly doubt is ,
We so far use the username ,password fields in most of our tutorials. particularly I used to practice in such a way that the password field might contain at least 8 characters, at least an Uppercase letter,at least a special character.
suppose If I have a website in my mother language like tamil (or probably be any of our Indian language... ) and in which I use a form with all field names in tamil , I expect the username and password in tamil itself so, can I able to validate the password field above with preg() functions??? Clearly, as per my expectation my user is going to type in the password field in tamil characters, incase he/she used other language (english, etc....) , my form might give him an error use only tamil or hindi or what ever the language may be... also others of my validation conditions. Is it possible in php????
I think I may clearly put forth my question to you, but if its not clear please give me a chance I will come up with screen shorts tomorrow.
if no please explain me why??? (.... is perl regular for only english??? ) also if yes please explain me how!
Waiting for your answer sir, ... thank you for your previous answers meet you again!
I would recommend taking help from <span id="docs-internal-guid-3097fac5-7fff-4e12-f2a3-54d48f119e77"><span style="font-size: 11pt; font-family: Cambria; color: rgb(17, 85, 204); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;"><a href="https://www.i2tutorials.com/cassandra-tutorial/">https://www.i2tutorials.com/cassandra-tutorial/</a></span></span>
Login to add comment