Re: Writing Arabic Text to a DataBase with Perl

2011-12-12 Thread Jon Forsyth
Hello Michaël, Thank you for the tips. SHOW CREATE TABLE helped me figure out that my table was using Latin1 and I was able to change it to utf-8. However, I did not see any encoding specified on the column with this command. I tried to fix the connection encoding with this line of Perl code:

Writing Arabic Text to a DataBase with Perl

2011-12-10 Thread Jon Forsyth
Hello, I hope someone can help me solve this. I am trying to write 2 string values to separate fields of the same row in a mysql DB table using the Perl Module DBD::mysql. One string value is of English letters, while the other is of Arabic letters. However, they are somehow switched and writte

Null Output Problem

2011-10-11 Thread Jon Forsyth
Hello, I have a problem with the following query: SELECT subject_identifier, COUNT(*) FROM asr_sentence_score WHERE total_words = correct_words GROUP BY subject_identifier; OutPut: ++--+ | subject_identifier | COUNT(*) | ++--+ |