Page 1 of 1

Non latin Posts SQL Addon Problem

PostPosted: Sun Nov 11, 2007 10:05 am
by Gmaniac

There is a problem in SQL Addon when posting non latin text. I had a convertation with a friend who is using joomla and he had the same problem that i have in Coranto.

I have check the Codepage in to be compatible with Greek Lang.(Windows-1253 or ISO 8859-7 or UTF-8), none of them can post in MySQL database with the correct character set. Also i have check many times and i have made many combinations without a result the character sets in phpMyAdmin.

Serching the internet i found that the same problem has many people from Greece using various scripts that connect to MySQL database, there is a solution that we have test with this friend and works in php connections to MySQL, we found in a forum that if you set the character set then the post will be correct. is there any posibility to set in Coranto SQL Addon the charsets? Below is the php example i dont know how can this be done in perl.

Direct Link to the post

Code: ( php )
adding these lines just after you connect to your MySQL database:
Code: Select all
mysql_query("SET NAMES 'utf8'", $dbConn);
mysql_query("SET CHARACTER SET 'utf8'", $dbConn);

Code: Select all
$conn = dbConnect();
mysql_query("set names 'utf8'", $conn);
mysql_query("set character set 'utf8'", $conn);
$sql = "select * from close";
$res = mysql_query($sql) or die (mysql_error());
$numrows = mysql_num_rows($res);

Without correct database records, any backup is useless.

My Configuration

Coranto 1.25

Addon Lister 1.2
Backup build 2 (privacy compliant)
ChangeDateNew 3.5.6
Chmod 0.2
CorantoSQL 5.0 Beta 18
CorantoSQL DB-Backup beta 2
CSS Editor beta build 1
CustomFields 1.0 (Build 24)
FieldIncluder 1.0
Filter By Field 2 2.1
Full Profile Build 1.0 (Build 1)
Maginot Build 17
Modify Date Format 1.1 (build 2)
Modify News : Missing Subject 0.1.2 (Build 3)
Modify News: User Column build 2 (privacy compliant)
Moveit! alfa build 1
MultiPage 1.51
Multipart 1.59 (Build 25)
NewFiles 1.1 (build 3)
News Categories build 10-RC8 (privacy compliant)
NumericNewsid 0.1
ProCheck 1.2
Profile Copier 1.01 (build 2)
Snipper 1.0.1
Style Debugger 0.2
Top Bottom News Fields 0.1
UserGroups unknown
WebWriter 3.2
X MultiSubmit 2.4.3


need you help, if tis possible

PostPosted: Tue Nov 20, 2007 4:41 pm
by Gmaniac

after many hours searching, i found some code samples in perl that could be help the problem above.

To be more specific this time when posting through coranto and the laguage settings are set to Greek ISO 8859-7 in Coranto and greek_general_ci in MySQL fields, Table & Database the result is no readable characters in modify news and the same thing in MySQL table

there must be a way to send charset properties when post & modify

code samples

$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
$this->query("SET NAMES 'greek_general_ci'");
$this->query("SET CHARACTER 'greek_general_ci'");


my $dbh = DBI->connect("dbi:mysql:test", "xxx", "yyy");
$dbh->do("set character set greek_general_ci");
$dbh->do("set names greek_general_ci");

Thanks in Advance