0

I need help with this query 

select ca_city from AM_PROVISIONAL where ca_province='پنجاب'  group by ca_city

when I run it, it shows the blank field but the database exists.

Victory
  • 5,581
  • 1
  • 25
  • 44
Awais
  • 1,084
  • 9
  • 14
  • Take a look at http://stackoverflow.com/questions/20074562/group-by-without-aggregate-function to understand how GROUP BY works – Shailendra Aug 30 '14 at 09:56
  • Are you sure your `AM_PROVISIONAL` table supports your character set? What does `SHOW CREATE TABLE AM_PROVISIONAL` print? – Victory Aug 30 '14 at 09:57
  • (1) Make sure your DB support the UTF8 character set (2) also provide some data of the ca_city and ca_province columns from the table – Rakesh Soni Aug 30 '14 at 10:10
  • sorry to all i just forget to write 'N' as it support and used for multilanguage. if we compare two different languages we have to use this. – Awais Aug 31 '14 at 15:33

0 Answers0