Public Forums 71,145 posts

[raj2010 Friend raj2010Join date: March 2014Posts: 23Downloads:0Uploads:3]

#196564

Hello,

I am new , i have no idea about SQL,

which is best format of SQL table(TEXT, CHAR) to install joomla Purity III

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#530016

<em>@raj2010 420589 wrote:</em><blockquote>Hello,

I am new , i have no idea about SQL,

which is best format of SQL table(TEXT, CHAR) to install joomla Purity III</blockquote>
Hello Raj
Please follow the simple steps to install quickstart.
Here is the link

[raj2010 Friend raj2010Join date: March 2014Posts: 23Downloads:0Uploads:3]

#530026

Dear Pankaj,

I have installed Quickstartpackage but issue is that i cant add Hindi text in any artical or post, because purity III or T-3 framework create latin1_swedish_ci database table

http://krishivibhag.com/index.php/hi/

I think T- 3 Framework dosenot support utf-8 chararcterset

please check
http://demo.t3-framework.org/joomla30/index.php/ar/homepage-ar

[mpurcell Friend mpurcellJoin date: March 2014Posts: 14Downloads:0Uploads:0 Thanks: 6 Thanked: 5 times in 2 posts]

#530073

raj2010

The charset of the database table needs to be set on the server. Your host, iPage if I see it correctly, is a standard Apache/2 PHP MySQL host. Go the the hosting control panel and open phpmyadmin. In that program you can set the charset for the existing sql tables for your site. If you are not familiar with using phpmyadmin, there are usually tutorials available on the host FAQ, or you can google it.

[raj2010 Friend raj2010Join date: March 2014Posts: 23Downloads:0Uploads:3]

#530086

<em>@mpurcell 420679 wrote:</em><blockquote>raj2010

The charset of the database table needs to be set on the server. Your host, iPage if I see it correctly, is a standard Apache/2 PHP MySQL host. Go the the hosting control panel and open phpmyadmin. In that program you can set the charset for the existing sql tables for your site. If you are not familiar with using phpmyadmin, there are usually tutorials available on the host FAQ, or you can google it.</blockquote>

Thanks for your support

Generally when we install Joomla it creates SQL database in utf-8 format , but when we install Puritry III is makes latin-sweden format SQL database

I have change SQL format but still cant store utf-8 character

[Author]

Posts