[billakos29]

Hello to all.
I'm making a database with greek data entry. I have 12 fields in the database. I dont know why, but i have problem
with capital "Π". it seams that it is not recognize this character but the strange is that this happens in the same column .
I have attach a picture to see the problem.
My second question is that i want to add an action button in each row. When you click it i want to generate a pdf (Such as crystal report) with some values from the specific row.
How to do it?

Thanks

[victor]

Hi!
What encoding are you using for database?

[billakos29]

database: utf8_unicode_ci and the tables also the same encoding.

[victor]

use the greek encoding!

[billakos29]

No it is not this the problem. I have already change the encoding but the problem remains.

[web-johnny]

Can you give the structure of the table? For example:

CREATE TABLE IF NOT EXISTS `employees` (

  `employeeNumber` int(11) NOT NULL AUTO_INCREMENT,

  `lastName` varchar(50) NOT NULL,

  `firstName` varchar(50) NOT NULL,

  `extension` varchar(10) NOT NULL,

  `email` varchar(100) NOT NULL,

  `officeCode` varchar(10) NOT NULL,

  `file_url` varchar(250) CHARACTER SET utf8 NOT NULL,

  `jobTitle` varchar(50) NOT NULL,

  PRIMARY KEY (`employeeNumber`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1703 ;

I never had a problem with the letter Π , you can also confirm that from the examples of the website. Make sure that all the files and are utf8 encoded and the database is [b]utf8_general_ci[/b]